Results of 1 - 10 of about 18 for encoding (0.007 sec.)
- Blob Functions – DuckDB 12714
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...AR . 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(value) Converts a value...ex(value) Converts a value from hexadecimal representation to a blob. hex(blob) Converts blob to VARCHAR using hexadecimal encoding. md5(blob) Returns the MD5 hash of the blob as a VARCHAR . md5_number(blob) Returns the MD5 hash of the blob as a HUGEINT... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Encodings Extension – DuckDB 12062
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...verview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Core Extensions Copy Markdown Encodings Extension The encodings extension adds supports for reading CSVs using more than 1,000 character encodings. For a complet...e list of supported encodings , see All Supported Encodings . For detailed information on character encoding, see the ICU data repository . Installing... - https://man.mtool.work/duckdb/1.3/core_extensions/encodings.html
- Information Schema – DuckDB 10792
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...ULL . VARCHAR NULL character_set_name Name of the character set, currently implemented as showing the name of the database encoding. VARCHAR 'UTF8' character_repertoire Character repertoire, showing UCS if the encoding is UTF8 , else just the encoding na...me. VARCHAR 'UCS' form_of_use Character encoding form, same as the database encoding. VARCHAR 'UTF8' default_collate_catalog Name of the database containing the default co... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Schema – DuckDB 10294
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...emap Live Demo Documentation / Guides / Performance Copy Markdown Schema Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode mor...ory during processing. Bestpractice Use the most restrictive types possible when creating columns. Avoid using strings for encoding more specific data items. Microbenchmark: Using Timestamps We illustrate the difference in aggregation speed using the cre... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- CSV Import – DuckDB 9334
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...vailable in the COPY statement. VARCHAR , escape String used to escape the quote character within quoted values. VARCHAR " encoding Encoding used by the CSV file. Options are utf-8 , utf-16 , latin-1 . Not available in the COPY statement (which always us...this option increases memory consumption. BOOL false Tip DuckDB's CSV reader supports UTF-8 (default), UTF-16 and Latin-1 encodings as well as many other encoding options natively through the encoding extension, for details see All Supported Encodings .... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Storage Versions and Format – DuckDB 9025
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...n-memory instances . Compression Algorithms The compression algorithms supported by DuckDB include the following: Constant Encoding Run-Length Encoding (RLE) Bit Packing Frame of Reference (FOR) Dictionary Encoding Fast Static Symbol Table (FSST) – VLDB... - https://man.mtool.work/duckdb/1.3/internals/storage.html
- PostgreSQL Extension – DuckDB 8047
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...OPY postgres_db.tbl TO 'data.parquet' ; COPY postgres_db.tbl FROM 'data.parquet' ; These copies use PostgreSQL binary wire encoding . DuckDB can also write data using this encoding to a file which you can then load into PostgreSQL using a client of your... - https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html
- Text Functions – DuckDB 8047
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...string . upper(string) Converts string to upper case. url_decode(string) Decodes a URL from a representation using Percent-Encoding . url_encode(string) Encodes a URL to a representation using Percent-Encoding . string[index] Description Extracts a singl...e upper('Hello') Result HELLO Alias ucase url_decode(string) Description Decodes a URL from a representation using Percent-Encoding . Example url_decode('https%3A%2F%2Fduckdb.org%2Fwhy_duckdb%23portable') Result https://duckdb.org/why_duckdb#portable url... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Bitstring Type – DuckDB 7738
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc...dded with zeroes. Bitstrings can be very large, having the same size restrictions as BLOB s. Creating a Bitstring A string encoding a bitstring can be cast to a BITSTRING : SELECT '101010' :: BITSTRING AS b ; b 101010 Create a BITSTRING with predefined l... - https://man.mtool.work/duckdb/1.3/sql/data_types/bitstring.html
- Python Client API – DuckDB 7566
- 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
...Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Sc..., escapechar : object = None , date_format : object = None , timestamp_format : object = None , quoting : object = None , encoding : object = None , compression : object = None , overwrite : object = None , per_thread_output : object = None , use_tmp_fi..., escapechar : object = None , date_format : object = None , timestamp_format : object = None , quoting : object = None , encoding : object = None , compression : object = None , overwrite : object = None , per_thread_output : object = None , use_tmp_fi... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
DuckDB 1.3 Documentation / man.mtool.work