Lines Matching full:collation
5310 ** ^These functions add, remove, or modify a [collation] associated
5313 ** ^The name of the collation is a UTF-8 string
5316 ** ^Collation names that compare equal according to [sqlite3_strnicmp()] are
5343 ** that collation is no longer usable.
5352 ** to the same collation name (using different eTextRep values) then all
5372 ** calls to the collation creation functions or when the
5410 ** CAPI3REF: Collation Needed Callbacks
5413 ** ^To avoid having to register all collation sequences before a database
5415 ** [database connection] to be invoked whenever an undefined collation
5419 ** then it is passed the names of undefined collation sequences as strings
5422 ** ^A call to either function replaces the existing collation-needed callback.
5428 ** or [SQLITE_UTF16LE], indicating the most desirable form of the collation
5430 ** required collation sequence.)^
5432 ** The callback function should register the desired collation using
5968 ** <tr><td> 6th <td> const char* <td> Name of default collation sequence
5976 ** declaration type and collation sequence is valid until the next
5990 ** collation sequence: "BINARY"
6006 char const **pzCollSeq, /* OUTPUT: Collation sequence name */
14904 KeyInfo *pKeyInfo; /* Collation and sort-order information */
14958 const char **azColl; /* Array of collation sequence names for index */
75307 ** using the collation sequence pColl. As usual, return a negative , zero
75487 /* The collation sequence must be defined at this point, even if
75488 ** the user deletes the collation sequence after the vdbe program is
75861 ** uses the collation sequence BINARY and (c) that the size-of-header varint
80031 ** or aggregate calls sqlite3GetFuncCollSeq(), this collation sequence will
80040 ** to retrieve the collation sequence set by this opcode is not available
86957 ** size nKey2 bytes). Use (pTask->pKeyInfo) for the collation sequences
86984 ** the first field of each key is a TEXT value and that the collation
91208 ** Return the collation sequence for the expression pExpr. If
91353 ** Return a pointer to the collation sequence that should be used by
91357 ** used. Otherwise the collation sequence for the right hand expression
92932 ** in pGroupBy that sort with the BINARY collation sequence.
101264 ** Set the collation function of the most recently parsed table column
101270 char *zColl; /* Dequoted name of collation sequence */
101286 ** collation type was added. Correct this if it is the case.
101300 ** This function returns the collation sequence for database native text
101303 ** If the requested collation
101304 ** in the database native encoding, the collation factory is invoked to
101305 ** request it. If the collation factory does not supply such a sequence,
101314 ** invokes the collation factory if the named collation cannot be found
102976 ** specified collation sequence names.
103034 const char *zColl; /* Collation sequence name */
104164 ** REINDEX <collation> -- 2
104345 ** of user defined functions and collation sequences.
104351 ** Invoke the 'collation needed' callback to request a collation sequence
104377 ** This routine is called if the collation factory fails to deliver a
104378 ** collation function in the best encoding but there may be other versions
104379 ** of this collation function (for other text encodings) available. Use one
104400 ** This function is responsible for invoking the collation factory callback
104401 ** or substituting a collation sequence of a different encoding when the
104402 ** requested collation sequence is not available in the desired encoding.
104405 ** collation sequence with name zName, length nName.
104407 ** The return value is either the collation sequence to be used in database
104408 ** db for collation type name zName, length nName, or NULL, if no collation
104409 ** sequence can be found. If no collation is found, leave an error message.
104427 /* No collation sequence of this type for this encoding is registered.
104428 ** Call the collation factory to see if it can supply us with one.
104438 sqlite3ErrorMsg(pParse, "no such collation sequence: %s", zName);
104444 ** This routine is called on a collation sequence before it is used to
104445 ** check that it is defined. An undefined collation sequence exists when
104446 ** a database is loaded that contains references to collation sequences
104449 ** If required, this routine calls the 'collation needed' callback to
104475 ** array of three CollSeq structures. The first is the collation sequence
104478 ** Stored immediately after the three collation sequences is a copy of
104479 ** the collation sequence name. A pointer to this string is stored in
104480 ** each collation sequence structure.
104522 ** Return the CollSeq* pointer for the collation sequence named zName
104529 ** this routine. sqlite3LocateCollSeq() invokes the collation factory
107847 ** the default collation sequences for each column. */
107851 const char *zDfltColl; /* Def. collation for column */
107856 /* If the index uses a collation sequence that is different from
107857 ** the default collation sequence for the column, this index is
108169 ** The collation sequence used for the comparison should be that of
108817 ** that the affinity and collation sequence associated with the
111237 ** collation sequence BINARY, then it can also be assumed that the
111244 ** If any of the indexed columns use a collation sequence other than
111246 ** might change the definition of a collation sequence and then run
117377 ** to get the number of columns and the collation sequence for each column.
118438 ** Add type and collation information to a column list based on
119610 ** collation.
121320 ** by selectExpander() but the type and collation information was omitted
121618 ** use the "BINARY" collation sequence.
129188 ** "Y collate NOCASE op X" becomes "X op Y" because any collation sequence on
129189 ** the left hand side of a comparison overrides any collation sequence
131010 ** where X is a constant value. The collation sequences of the
132786 CollSeq *pColl; /* Comparison collation sequence */
141471 ** of strings is ignored. This implements the RTRIM collation.
141480 /* EVIDENCE-OF: R-65033-28449 The built-in BINARY collation compares
141799 /* Invoke any destructors registered for collation sequence user data. */
142982 /* Check if this call is removing or replacing an existing collation
142990 "unable to delete/modify collation sequence due to active statements");
142995 /* If collation sequence pColl was created directly by a call to
142998 ** Also, collation destructor - CollSeq.xDel() - function may need
143537 /* Add the default collation sequence BINARY. BINARY works for both UTF-8
143790 ** Register a new collation sequence with the database handle db.
143803 ** Register a new collation sequence with the database handle db.
143828 ** Register a new collation sequence with the database handle db.
143857 ** Register a collation sequence factory callback with the database handle
143858 ** db. Replace any previously installed collation sequence factory.
143878 ** Register a collation sequence factory callback with the database handle
143879 ** db. Replace any previously installed collation sequence factory.
143985 char const **pzCollSeq, /* OUTPUT: Collation sequence name */
168030 ** * Integration of ICU and SQLite collation sequences.
168416 ** Collation sequence destructor function. The pCtx argument points to
168425 ** Collation sequence comparison function. The pCtx argument points to
168450 ** This scalar function is used to add ICU collation based collation
168454 ** SELECT icu_load_collation(<locale>, <collation-name>);
168457 ** "en_AU", "tr_TR" etc.) and <collation-name> is the name of the
168458 ** collation sequence to create.
168468 const char *zName; /* SQL Collation sequence name (eg. "japanese") */
168469 UCollator *pUCollator; /* ICU library collation object */
168493 sqlite3_result_error(p, "Error registering collation function", -1);
171226 ** collation sequences. For tables that do not have an external PRIMARY
174259 ** If the paths are sorted using the BINARY collation sequence, then
