UNICODE function [String]

Returns an integer containing the Unicode code point of the first character in the string, or NULL if the first character is not a valid encoding.

Syntax
UNICODE( nchar-string-expression )
Parameters
  • nchar-string-expression   The NCHAR string whose first character is to be converted to an integer.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following example returns the integer 65536:

SELECT UNICODE(UNISTR( '\u010000data' ));