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' ));
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0