SQL UNICODE Function

The UNICODE function returns an integer value representing a Unicode character.

UNICODE returns a value in the hex range of 000000 through 00FFFF.

This range is capable of representing the 65,535 Unicode characters.

Example

#

Return an integer representing the specified Unicode character.

SELECT UNICODE('A') AS 'Unicode(A)',
       UNICODE('d') AS 'Unicode(d)',
       UNICODE('ø') AS 'Unicode(ø)'
Result:  1 record
Unicode(A) Unicode(d) Unicode(ΓΈ)
65 100 248

Syntax

Syntax of the UNICODE function.

UNICODE(character)

character -- the character to convert to a Unicode integer value.


You may also like



Guides


vsn 3.1