How to check code point value of a Unicode character in SQL Server?

ByAnkush Jain| Last Updated On Tuesday, Oct 23, 2018

SQL Server

Disclaimer: I am a consultant at Amazon Web Services, and this is my personal blog. The opinions expressed here are solely mine and do not reflect the views of Amazon Web Services (AWS). Any statements made should not be considered official endorsements or statements by AWS.

To determine the code-point value of a Unicode character in SQL Server, you can use UNICODE() function which is provided by default in SQL Server.

What is Code Point?

• Every character in a character set (ASCII, UNICODE etc.) is assigned a numeric value, which is known as Code Point.
• A Unicode Code Point is a unique number assigned to each Unicode character.

For example, if you want to determine the code-point value of the English letter A, then you simply need to write the below command in SQL Server.

SELECT UNICODE('A')

This will output its code-point value.

You may have to prefix N before the character if the character is a Non-ASCII character. N stands for National Language Character Set.

SELECT UNICODE(N'ह')

See the below example image: