Results of 1 - 7 of about 7 for hexadecimal (0.004 sec.)
- Literal Types 11905
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...eger literal 42 can be implicitly converted to a TINYINT , but the integer literal 1000 cannot be. DuckDB does not support hexadecimal or binary literals directly. However, strings or string literals in hexadecimal or binary notation with 0x or 0b prefixes...als as an optional separator. The rules for using underscores are as follows: Underscores are allowed in integer, decimal, hexadecimal and binary notation. Hexadecimal notation uses the 0x prefix and binary notation uses the 0b prefix, as described in the I.... A string literal prefixed with X is a hex string literal, which produces a BLOB value. It must contain an even number of hexadecimal digits. SELECT B'0101' AS b, X'CAFE' AS x; ┌──────┬──────────┐ │ b │ x │ │ bit │ blob │ ├──────┼──────────┤ │ 0101 │ \xCA\... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Blob Functions 11050
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . 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...ob) Alias for hex . unbin(value) Converts a value from binary representation to a blob. unhex(value) Converts a value from hexadecimal representation to a blob. arg1 || arg2 | Description | Concatenates two strings, lists, or blobs. Any NULL input results i...ring ( BLOB ). | | Example | from_base64('QQ==') | | Result | A | hex(blob) | Description | Converts blob to VARCHAR using hexadecimal encoding. | | Example | hex('\xAA\xBB'::BLOB) | | Result | AABB | | Alias | to_hex | md5(blob) | Description | Returns the... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Text Functions 9705
- 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
...urns a UBIGINT with the hash of the value . Note that this is not a cryptographic hash. hex(string) Converts the string to hexadecimal representation. ilike_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifi...) Alias for upper . unbin(value) Converts a value from binary representation to a blob. unhex(value) Converts a value from hexadecimal representation to a blob. unicode(string) Returns an INTEGER representing the unicode codepoint of the first character in...raphic hash. | | Example | hash('?') | | Result | 4164431626903154684 | hex(string) | Description | Converts the string to hexadecimal representation. | | Example | hex('Hello') | | Result | 48656C6C6F | | Alias | to_hex | ilike_escape(string, like_specifie... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Cloudflare R2 Import 8869
- Prerequisites For Cloudflare R2, the S3 Compatibility API allows you to use DuckDB's S3 support to read and write from R2 buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only needs to
...E r2, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', ACCOUNT_ID '⟨your-32-character-hexadecimal-account-ID⟩' ); Querying After setting up the R2 credentials, you can query the R2 data using DuckDB's built-in methods, s... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/cloudflare_r2_imp...
- Blob Type 8360
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...h two bytes (65, 66): SELECT 'AB'::BLOB; A BLOB value can also be created using a hex string literal, which is a string of hexadecimal digits prefixed with X . The number of hex digits must be even. For example, create a BLOB value with two bytes (202, 254)... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- Numeric Types 7179
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...UID type. These use 128 bits and are represented internally as HUGEINT values. When printed, they are shown with lowercase hexadecimal characters, separated by dashes as follows: ⟨12345678⟩-⟨1234⟩-⟨1234⟩-⟨1234⟩-⟨1234567890ab⟩ (using 36 characters in total i... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Python Client API 6506
- 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
...value from binary representation to a blob. SQL: unbin . unhex ( * args : ValueOrExpr ) → Expression Converts a value from hexadecimal representation to a blob. SQL: unhex . unicode ( * args : ValueOrExpr ) → Expression The Unicode code point of the first c... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work