Get Unicode Vlue of Character in SQL Server 2012

Jignesh Trivedi

11y818Code

This code snippet for Get Unicode value of character in SQL server 2012.

UNICODE function returns the integer value as defined by the Unicode standard. It works for only first character of the input expression.

Syntax

UNICODE ( 'ncharacter_expression' )

Example 1:

DECLARE @nstring nchar(7)
SET @nstring = N'Jignesh'
SELECT UNICODE(@nstring)

Result:

Example 2:

DECLARE @nstring nchar(1)
SET @nstring = N'§'
SELECT UNICODE(@nstring)

Result:

167