Results of 1 - 10 of about 10 for Unicode (0.004 sec.)
- Text Functions 12639
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...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[, width]) Draws a band whose width is proportional to (...acter_length(string) Alias for length . chr(code_point) Returns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates multiple strings or lists. NULL inputs are skipped. See also operator || . con...ng) Returns the upper 64-bit segment of the MD5 hash of the string as a UBIGINT . nfc_normalize(string) Converts string to Unicode NFC normalized string. Useful for comparisons and ordering if text data is mixed between NFC normalized and not. not_ilike... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Output Formats 11531
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...n mode is particularly useful for building documentation and the latex mode is useful for writing academic papers. Warning Unicode handling in Windows Terminal When long results are displayed in Windows Terminal the more system utility is used by defaul...t to provide the scrolling through the results. This utility has incomplete support of Unicode, depending on the output data, in some cases it can display Unicode characters in garbled form. We suggest using the third...r\bin\less.exe" -R' 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 Output in columns (See .width ) duckbox Tables with extensive fea... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Text Types 10100
- 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
...E strings ( val VARCHAR CHECK (length(val) <= 10) -- val has a maximum length of 10 ); The VARCHAR field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Specifying a Compression Type You can specify a compression type for... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
- Collations 8670
- 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
...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, however, by far the fastest method of performing ordering and comparisons. Hence it is recommended to s...ation compares characters as equal regardless of their accents. The NFC collation performs NFC-normalized comparisons, see Unicode normalization for more information. SELECT 'hello' = 'hElLO'; false SELECT 'hello' COLLATE NOCASE = 'hElLO'; true SELECT '... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
- Python Client API 8366
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...', 'VARCHAR']), 'trim': ('trim', 0, ['VARCHAR']), 'unbin': ('unbin', 0, ['VARCHAR']), 'unhex': ('unhex', 0, ['VARCHAR']), 'unicode': ('unicode', 0, ['VARCHAR']), 'upper': ('upper', 0, ['VARCHAR']), 'url_decode': ('url_decode', 0, ['VARCHAR']), 'url_enco...)} Method name to (function, position of the expression, parameter types). ascii ( * args : ValueOrExpr ) → Expression The Unicode code point of the first character. SQL: ascii . bin ( * args : ValueOrExpr ) → StrExpr Converts the string to binary repre...D5 hash of the string as a HUGEINT . SQL: md5_number . nfc_normalize ( * args : ValueOrExpr ) → StrExpr Converts string to Unicode NFC normalized string. SQL: nfc_normalize . not_ilike_escape ( * args : ValueOrExpr ) → Expression Does not match, ignorin... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- ODBC Extension 8205
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...r={IBM DB2 ODBC DRIVER};HostName=127.0.0.1;Port=50000;Database=testdb;UID=db2inst1;PWD=pwd; PostgreSQL: Driver={PostgreSQL Unicode};Server=127.0.0.1;Port=5432;Username=postgres;Password=postgres;Database=test_db; MySQL/MariaDB: Driver={MariaDB ODBC 3.1...45.snowflakecomputing.com;Database=SNOWFLAKE_SAMPLE_DATA;UID=username;PWD=pwd; ClickHouse: Driver={ClickHouse ODBC Driver (Unicode)};Server=127.0.0.1;Port=8123; Spark: Driver={Simba Spark ODBC Driver};Host=127.0.0.1;Port=10000; Arrow Flight SQL (Dremio... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Timestamp Issues 7883
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...vided by the icu extension . Starting with DuckDB 2.0, the extension no longer depends on the International Components for Unicode (ICU) library: it implements time zones and calendars natively, using time zone data built from the IANA time zone databas... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Timestamp Types 7401
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...its own calendar implementation. Despite its name, the icu extension no longer depends on the International Components for Unicode (ICU) library: starting with DuckDB 2.0, it implements time zones, calendars and collations natively. To set the time zone... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Dot Commands 7240
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...ox mode. .mode MODE ?TABLE? Set output mode MODE is one of: ascii Columns/rows delimited by 0x1F and 0x1E box Tables using unicode box-drawing characters csv Comma-separated values column Output in columns. (See .width) duckbox Tables with extensive fea... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Command Line Client 7240
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...prompt.sql will change the DuckDB prompt to be a duck head and run a SQL statement. Note that the duck head is built with Unicode characters and does not work in all terminal environments (e.g., in Windows, unless running with WSL and using the Windows... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work