Earn income with your data and sql skills
Sign up and we'll send you the best freelance opportunities straight to your inbox.
We're building the largest self-service freelancing marketplace for people like you.

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



Earn income with your data and sql skills
Sign up and we'll send you the best freelance opportunities straight to your inbox.
We're building the largest self-service freelancing marketplace for people like you.

Guides


vsn 3.1