Text & patterns
Scalar
unicode()
Returns an INTEGER representing the unicode codepoint of the first character in the string.
Arguments & returns
unicode(string)
Scalar
| Overload link | string |
Returns |
|---|---|---|
| #01 | VARCHAR |
INTEGER |
Example
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
In other engines
Used in larger rewrites 1
These examples use unicode as one part of a larger SQL translation.
Snowflakeunicode()
UNICODE(foo)
In DuckDBCASE WHEN foo = '' THEN 0 ELSE UNICODE(foo) END