⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 1.3 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 8 of about 8 for encoded (0.005 sec.)
Blob Functions – DuckDB 12417
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 ... esults in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2) . base64(blob) Converts a blob to a base64 encoded string. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs are skipped. See also operator || . ... ring) 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 from binary representation to a blob. from_hex( ... the blob . sha256(blob) Returns a VARCHAR with the SHA-256 hash of the blob . to_base64(blob) Converts a blob to a base64 encoded string. to_hex(blob) Converts blob to VARCHAR using hexadecimal encoding. unbin(value) Converts a value from binary repres ...
https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
Spatial Functions – DuckDB 11151
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 ... eomFromGeoJSON Deserializes a GEOMETRY from a GeoJSON fragment. ST_GeomFromHEXEWKB Deserialize a GEOMETRY from a HEX(E)WKB encoded string ST_GeomFromHEXWKB Deserialize a GEOMETRY from a HEX(E)WKB encoded string ST_GeomFromText Deserialize a GEOMETRY fro ... m a WKT encoded string ST_GeomFromWKB Deserializes a GEOMETRY from a WKB encoded blob ST_GeometryType Returns a 'GEOMETRY_TYPE' enum ident ... put line geometry, optionally taking direction into account. ST_LineString2DFromWKB Deserialize a LINESTRING_2D from a WKB encoded blob ST_LineSubstring Returns a substring of a line between two fractions of total 2D length. ST_M Returns the M coordinat ...
https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
Text Types – DuckDB 9543
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 ... uckDB, 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( ... 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 a string with the USING COMPRESSION clause. ... 連キーワード length strings type characters character Specifying Text storage text literals Types allows Unicode Internally encoded Variable maximum effect compatibility reasons example Type compression zstd Values 関連するページ Bitstring Type Informati ...
https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
Text Functions – DuckDB 9073
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 ... 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 string to binary representation. bit_length(string) Number of bits in a string . char_len ... uman-readable representation 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( ... n the given base radix , optionally padding with leading zeros to min_length . to_base64(blob) Converts a blob to a base64 encoded string. to_binary(string) Converts the string to binary representation. to_hex(string) Converts the string to hexadecimal ...
https://man.mtool.work/duckdb/1.3/sql/functions/text.html
DuckLake – DuckDB 8115
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 ... ake catalog name catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the following schema: Column name Column type snapshot_id BIGINT snapshot_time TIMESTAMP WITH TIME ZONE ... ke catalog named catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the following schema: Column name Column type table_name VARCHAR schema_id BIGINT table_id BIGINT table_ ...
https://man.mtool.work/duckdb/1.3/core_extensions/ducklake.html
Azure Extension – DuckDB 7627
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 ... socks proxies). On all operating systems, it will honor the following environment variables: CURL_CA_INFO : Path to a PEM encoded file containing the certificate authorities sent to libcurl. Note that this option is known to only work on Linux and migh ... t throw if set on other platforms. CURL_CA_PATH : Path to a directory which holds PEM encoded files, containing the certificate authorities sent to libcurl. Example: SET azure_http_stats = false ; SET azure_read_tran ...
https://man.mtool.work/duckdb/1.3/core_extensions/azure.html
Functions – DuckDB 7320
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 ... qual to width characters when x = max. width defaults to 80 base64 scalar VARCHAR [blob] [BLOB] Convert a blob to a base64 encoded string bin scalar VARCHAR [value] [VARCHAR] Converts the value to binary representation bit_count scalar TINYINT [x] [TINY ...
https://man.mtool.work/duckdb/1.3/sql/functions/overview.html
CSV Auto Detection – DuckDB 6994
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 ... ent Comment character # SkipRows Number of rows skipped 1 HasHeader Whether the CSV has a header true Columns Column types encoded as a LIST of STRUCT s ({'name': 'VARCHAR', 'age': 'BIGINT'}) DateFormat Date format %d/%m/%Y TimestampFormat Timestamp For ...
https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
PREV 1 NEXT
DuckDB 1.3 Documentation / man.mtool.work