Results of 1 - 10 of about 10 for ascii (0.004 sec.)
- Command Line Arguments – DuckDB 12389
- 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
...ble in the CLI shell, see the Dot Commands page . Argument Description -append Append the database to the end of the file -ascii Set output mode to ascii -bail Stop after hitting an error -batch Force batch I/O -box Set output mode to box -column Set...de DuckDB line list table command options database column stdin exit json separator Default Arguments duckdb help commands ascii after batch Force before reading 関連するページ CLI Client Output Formats Dot Commands CSV Export JSON Export Connect See... - https://man.mtool.work/duckdb/1.3/clients/cli/arguments.html
- Output Formats – DuckDB 12067
- 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
...r building documentation and the latex mode is useful for writing academic papers. List of Output Formats Mode Description ascii Columns/rows delimited by 0x1F and 0x1E box Tables using unicode box-drawing characters csv Comma-separated values column...de line One value per line list Values delimited by | markdown Markdown table format quote Escape answers as for SQL table ASCII-art table tabs Tab-separated values tcl TCL list elements trash No output Changing the Output Format Use the vanilla .mode...l_2 ; col_1|col_2 1|2 10|20 duckbox Mode By default, DuckDB renders query results in duckbox mode, which is a feature-rich ASCII-art style output format. The duckbox mode supports the large_number_rendering option, which allows human-readable renderin... - https://man.mtool.work/duckdb/1.3/clients/cli/output_formats.html
- Text Functions – DuckDB 10100
- 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
...ex . array_slice(list, begin, end) Extracts a sublist or substring using slice conventions . Negative values are accepted. ascii(string) Returns an integer that represents the Unicode code point of the first character of the string . bar(x, min, max[,.... character_length(string) Number of characters in string . chr(code_point) Returns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs are skipp...k Example 2 array_slice('DuckDB', 3, NULL) Result NULL Example 3 array_slice('DuckDB', 0, -3) Result Duck Alias list_slice ascii(string) Description Returns an integer that represents the Unicode code point of the first character of the string . Examp... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Importing Duckbox Tables – DuckDB 8152
- 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
...on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim in other documents. For example, take the table u... - https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html
- Encodings Extension – DuckDB 7812
- 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
...859_15 5 8859_2 6 8859_3 7 8859_4 8 8859_5 9 8859_6 10 8859_7 11 8859_8 12 8859_9 13 aix-IBM_udcJP-4.3.6 14 ANSI_X3.110 15 ascii 16 ASMO_449 17 BALTIC 18 big5 19 CNS11643.1986_1 20 CNS11643.1986_2 21 CNS-11643-1992 22 cp037 23 cp1026 24 CP1250 25 CP12...iso-8859_7-1987 738 iso-8859_7-2003 739 ISO8859_8 740 iso-8859_8-1999 741 ISO8859_9 742 iso-8859_9-1999 743 iso89 744 java-ASCII-1.3_P 745 java-Big5-1.3_P 746 java-Cp037-1.3_P 747 java-Cp1006-1.3_P 748 java-Cp1025-1.3_P 749 java-Cp1026-1.3_P 750 java-... - https://man.mtool.work/duckdb/1.3/core_extensions/encodings.html
- Literal Types – DuckDB 7812
- 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
...──────────┤ │ Hello\nworld │ └──────────────┘ The following backslash escape sequences are supported: Escape sequence Name ASCII code \b backspace 8 \f form feed 12 \n newline 10 \r carriage return 13 \t tab 9 Dollar-Quoted String Literals DuckDB supp... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Keywords and Identifiers – DuckDB 7812
- 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
...also treats quoted identifiers as case-insensitive. Comparison of identifiers: Case-insensitivity is implemented using an ASCII-based comparison: col_A and col_a are equal but col_á is not equal to them. SELECT col_A FROM ( SELECT 'x' AS col_a ); --... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- Collations – DuckDB 7812
- 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
...used. 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.... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- ORDER BY Clause – DuckDB 7812
- 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
...ary comparison collation by default, which means values are sorted on their binary UTF-8 values. While this works well for ASCII text (e.g., for English language data), the sorting order can be incorrect for other languages. For this purpose, DuckDB p... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/orderby.html
- Profiling – DuckDB 7490
- 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
...performance numbers. The FORMAT Option The EXPLAIN [ANALYZE] statement allows exporting to several formats: text – default ASCII-art style output graphviz – produces a DOT output, which can be rendered with Graphviz html – produces an HTML output, whi... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work