unicode()

Returns the unicode codepoint of the first character of the string

Arguments & returns

Scalar

Overload link	`str`	Returns
#01	`VARCHAR`	`INTEGER`

SELECT [unicode('âbcd'), unicode('â'), unicode(''), unicode(NULL)];

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  unicode('ü');

Used in larger rewrites 1

These examples use unicode as one part of a larger SQL translation.

UNICODE(foo)

In DuckDB

CASE WHEN foo = '' THEN 0 ELSE UNICODE(foo) END