Dofactory.com
Dofactory.com
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 freelancing marketplace for people like you.
By adding your name & email you agree to our terms, privacy and cookie policies.

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



Last updated on Dec 21, 2023

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 freelancing marketplace for people like you.
By adding your name & email you agree to our terms, privacy and cookie policies.