Results of 1 - 9 of about 9 for collation (0.004 sec.)
- Collations – DuckDB 13984
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...rview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Collations Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for loc...etter y comes between x and z . However, in Lithuanian the letter y comes between the i and j . For that reason, different collations are supported. The user must choose which collation they want to use when performing sorting and comparison operations. B... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- SET and RESET Statements – DuckDB 8915
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...tion to default value: RESET threads ; Retrieve configuration value: SELECT current_setting ( 'threads' ); Set the default collation for the session: SET SESSION default_collation = 'nocase' ; Set a Global Variable Set the default sort order globally: SET...efault threads DuckDB option Configuration options used Statements statement provided specified scope memory limit current collation session sort order globally reset instance Documentation Copy 関連するページ Configuration Configuration Securing DuckDB O... - https://man.mtool.work/duckdb/1.3/sql/statements/set.html
- ORDER BY Clause – DuckDB 8663
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...he default_order to change the direction of the default sorting order to either DESC or ASC : SET default_order = 'DESC' ; Collations Text is sorted using the binary comparison collation by default, which means values are sorted on their binary UTF-8 valu....g., for English language data), the sorting order can be incorrect for other languages. For this purpose, DuckDB provides collations. For more information on collations, see the Collation page . Examples All examples use this example table: CREATE OR REP... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/orderby.html
- ICU Extension – DuckDB 8538
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...Demo Documentation / Core Extensions Copy Markdown ICU Extension The icu extension contains an easy-to-use version of the collation/timezone part of the ICU library . Installing and Loading The icu extension will be transparently autoloaded on first use...it manually, run: INSTALL icu ; LOAD icu ; Features The icu extension introduces the following features: Region-dependent collations Time zones , used for timestamp data types and timestamp functions 関連キーワード extension timestamp Documentation Core... - https://man.mtool.work/duckdb/1.3/core_extensions/icu.html
- Information Schema – DuckDB 8412
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...ng form, same as the database encoding. VARCHAR 'UTF8' default_collate_catalog Name of the database containing the default collation (always the current database). VARCHAR 'my_db' default_collate_schema Name of the schema containing the default collation....VARCHAR 'pg_catalog' default_collate_name Name of the default collation. VARCHAR 'ucs_basic' columns : Columns The view that describes the catalog information for columns is information_schema.c... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Python Client API – DuckDB 8232
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...ckDBPyType ¶ Create a type object by parsing the ‘type_str' string string_type ( self : duckdb.duckdb.DuckDBPyConnection , collation : str = '' ) → duckdb.duckdb.typing.DuckDBPyType ¶ Create a string type with an optional collation struct_type ( self : du...self Parameters: type: The type to cast to Returns: CastExpression: self::type collate ( self : duckdb.duckdb.Expression , collation : str ) → duckdb.duckdb.Expression ¶ desc ( self : duckdb.duckdb.Expression ) → duckdb.duckdb.Expression ¶ Set the order b... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Configuration – DuckDB 8034
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...block_size The default block size for new duckdb database files (new as-in, they do not yet exist). UBIGINT 262144 default_collation The collation setting used when none is specified VARCHAR default_null_order , null_order NULL ordering used when none is... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Pragmas – DuckDB 8034
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...higher than the specified memory limit. Threads Set the amount of threads for parallel query execution: SET threads = 4 ; Collations List all available collations: PRAGMA collations ; Set the default collation to one of the available ones: SET default_co...uckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Metadata Resource Management Collations Default Ordering for NULLs Ordering by Non-Integer Literals Implicit Casting to VARCHAR Python: Scan All Dataframes Infor... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Types API – DuckDB 7980
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...p NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Fun...int scale: int union_type Parameters: members: Union[list[DuckDBPyType], dict[str, DuckDBPyType]] string_type Parameters: collation: Optional[str] 関連キーワード type DuckDBPyType duckdb typing Union dict types objects list import Parameters DuckDB uint... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work