Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

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.

UNICODE( nchar-string-expression )

nchar-string-expression    The NCHAR string whose first character is to be converted to an integer.

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

• SQL/2003    Vendor extension.

The following example returns the integer 65536:

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