Results of 1 - 3 of about 3 for unbin (0.004 sec.)
- Blob Functions 11886
- 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
...ncoding. from_base64(string) Converts a base64 encoded string to a character string ( 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 M...th the SHA-256 hash of the blob . to_base64(blob) Converts a blob to a base64 encoded string. to_hex(blob) Alias for hex . unbin(value) Converts a value from binary representation to a blob. unhex(value) Converts a value from hexadecimal representatio...on | Converts a blob to a base64 encoded string. | | Example | to_base64('A'::BLOB) | | Result | QQ== | | Alias | base64 | unbin(value) | Description | Converts a value from binary representation to a blob. | | Example | unbin('0110') | | Result | \x0... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Text Functions 8389
- 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
..., etc.). from_base64(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Alias for unbin . from_hex(value) Alias for unhex . greatest(arg1, ...) Returns the largest value in lexicographical order. Note that lowe...s of any of the characters from either side of the string . characters defaults to space . ucase(string) Alias for upper . unbin(value) Converts a value from binary representation to a blob. unhex(value) Converts a value from hexadecimal representatio...s to space . | | Example 1 | trim(' test ') | | Result | test | | Example 2 | trim('>>>>test<<', '><') | | Result | test | unbin(value) | Description | Converts a value from binary representation to a blob. | | Example | unbin('0110') | | Result | \x0... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Python Client API 7608
- 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
...ARCHAR', 'VARCHAR']), 'translate': ('translate', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR']), 'trim': ('trim', 0, ['VARCHAR']), 'unbin': ('unbin', 0, ['VARCHAR']), 'unhex': ('unhex', 0, ['VARCHAR']), 'unicode': ('unicode', 0, ['VARCHAR']), 'upper': ('upper'...e . trim ( * args : ValueOrExpr ) → StrExpr Trimmed on both sides of any of the characters, spaces by default. SQL: trim . unbin ( * args : ValueOrExpr ) → Expression Converts a value from binary representation to a blob. SQL: unbin . unhex ( * args :... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work