Results of 1 - 10 of about 26 for characters (0.006 sec.)
- Text Functions – DuckDB 15869
- 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
...acter of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Converts a blob to a base64 encoded string. bin(string) Converts the str...ing to binary representation. bit_length(string) Number of bits in a string . char_length(string) Number of characters in string . character_length(string) Number of characters in string . chr(code_point) Returns a character which is corresp...entation using units based on powers of 2 (KiB, MiB, GiB, etc.). from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Converts a value from binary representation to a blob. from_hex(value) Converts a value... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Text Types – DuckDB 9951
- 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
...Types Copy Markdown Text Types In DuckDB, strings can be stored in the VARCHAR field. The field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length...character string VARCHAR(n) CHAR(n) , BPCHAR(n) , STRING(n) , TEXT(n) Variable-length character string. The maximum length n has no effect and is only provided for compatibility Specifying a Length Limit Specifying the...ity reasons with other systems that do require a length to be specified for strings. If you wish to restrict the number of characters in a VARCHAR column for data integrity reasons the CHECK constraint should be used, for example: CREATE TABLE strings ( va... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Pattern Matching – DuckDB 9951
- 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
...core ( _ ) in pattern stands for (matches) any single character; a percent sign ( % ) matches any sequence of zero or more characters. LIKE pattern matching always covers the entire string. Therefore, if it's desired to match a sequence anywhere within a s...' ; -- false Case-insensitive ILIKE with ESCAPE: SELECT 'A%c' ILIKE 'a$%c' ESCAPE '$' ; -- true There are also alternative characters that can be used as keywords in place of LIKE expressions. These enhance PostgreSQL compatibility. PostgreSQL-style LIKE -...is unlike common regular expression behavior where the pattern can match any part of the string. A regular expression is a character sequence that is an abbreviated definition of a set of strings (a regular set). A string is said to match a regular express... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Collations – DuckDB 8811
- 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
...That means that strings are ordered and compared based only on their binary contents. This makes sense for standard ASCII characters (i.e., the letters A-Z and numbers 0-9), but generally does not make much sense for special unicode characters. It is, how...tand-alone installation of DuckDB three collations are included: NOCASE , NOACCENT and NFC . The NOCASE collation compares characters as equal regardless of their casing. The NOACCENT collation compares characters as equal regardless of their accents. The..., "Göthe", "Götz" 関連キーワード names collation collations Collations different hello used combined rules default strings characters also collator specified column These comparison their however hElLÖ hännes need region specific 関連するページ CSV Import... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- JSON Overview – DuckDB 8348
- 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
...s value with a JSONPath expression as a VARCHAR : SELECT j ->> '$.family' FROM example ; anatidae Using Quotes for Special Characters JSON object keys that contain the special [ and . characters can be used by surrounding them with double quotes ( " ): SEL...ON Pointer Syntax Indexing Examples Loading JSON Writing JSON JSON Data Type Retrieving JSON Data Using Quotes for Special Characters... - https://man.mtool.work/duckdb/1.3/data/json/overview.html
- Dot Commands – DuckDB 8050
- 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
...maxrows COUNT Sets the maximum number of rows for display. Only for duckbox mode .maxwidth COUNT Sets the maximum width in characters. 0 defaults to terminal width. Only for duckbox mode .mode MODE TABLE Set output mode .multiline Set multi-line mode (defa...the maximum number of rows for display ( default : 40 ). Only for duckbox mode . .maxwidth COUNT Sets the maximum width in characters . 0 defaults to terminal width . Only for duckbox mode . .mode MODE ? TABLE ? Set output mode .output : Writing Results to...sabled using .highlight_results off . Shorthands DuckDB's CLI allows using shorthands for dot commands. Once a sequence of characters can unambiguously completed to a dot command or an argument, the CLI (silently) autocompletes them. For example: .mo ma Is... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Keywords and Identifiers – DuckDB 7951
- 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
...ber or special character, e.g., SELECT 123 AS 1col is invalid. They cannot contain whitespaces (including tabs and newline characters). Identifiers can be quoted using double-quote characters ( " ). Quoted identifiers can use any keyword, whitespace or spe... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- Blob Functions – DuckDB 7951
- 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
...) Converts blob to VARCHAR . Fails if blob is not valid UTF-8. encode(string) Converts the string to BLOB . Converts UTF-8 characters into literal encoding. from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(va...d UTF-8. Example decode('\xC3\xBC'::BLOB) Result ü encode(string) Description Converts the string to BLOB . Converts UTF-8 characters into literal encoding. Example encode('my_string_with_ü') Result my_string_with_\xC3\xBC from_base64(string) Description C...onverts a base64 encoded string to a character string ( BLOB ). Example from_base64('QQ==') Result A from_binary(value) Description Converts a value from binary represent... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- S3 API Support – DuckDB 7835
- 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
...e passed to use temporary credentials S3 , GCS , R2 STRING - URL_COMPATIBILITY_MODE Can help when URLs contain problematic characters S3 , GCS , R2 BOOLEAN true URL_STYLE Either vhost or path S3 , GCS , R2 STRING vhost for S3 , path for R2 and GCS USE_SSL..., such as * to match any number of any character, ? for any single character or [0-9] for a single character in a range of characters: SELECT count ( * ) FROM read_parquet ( 's3:// your-bucket /folder*/100?/t[0-9].parquet' ); A useful feature when using gl... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
- CSV Auto Detection – DuckDB 7835
- 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
...ption. If this is set all columns will remain as VARCHAR (as they originally occur in the CSV file). Note that using quote characters vs. no quote characters (e.g., "42" and 42 ) does not make a difference for type detection. Quoted fields will not be conv... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
DuckDB 1.3 Documentation / man.mtool.work