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

Returns

INT

See also

• CONNECTION_EXTENDED_PROPERTY function [String]
• NCHAR function [String]
• TO_CHAR function [String]
• TO_NCHAR function [String]
• UNISTR function [String]

Standards and compatibility

Example

The following example returns the integer 65536:

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