Results of 1 - 2 of about 2 for collator (0.001 sec.)
- Collations 11228
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
...however, that not all collations can be combined together. In general, the NOCASE collation can be combined with any other collator, but most other collations cannot be combined. SELECT 'hello' COLLATE NOCASE = 'hElLÖ'; false SELECT 'hello' COLLATE NOACC...tions The collations we have seen so far have all been specified per expression . It is also possible to specify a default collator, either on the global database level or on a base table column. The PRAGMA default_collation can be used to specify the gl...obal default collator. This is the collator that will be used if no other one is specified. SET default_collation = NOCASE; SELECT 'hello' = 'He... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
- Utility Functions 7485
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...e) Returns a UBIGINT with a hash of value . The used hash function may change across DuckDB versions. icu_sort_key(string, collator) Surrogate sort key used to sort special characters according to the specific locale. Collator parameter is optional. Only...unction may change across DuckDB versions. | | Example | hash('?') | | Result | 4164431626903154684 | icu_sort_key(string, collator) | Description | Surrogate sort key used to sort special characters according to the specific locale. Collator parameter i... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work