Login Join Us
SQL Reference 
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 NCHAR Function

The NCHAR function returns a Unicode character for a given integer value.

It accepts an integer value from 0 to 65535, or a hex value from 0 through 0xFFFF.

If the value provided exceeds the range, a NULL value is returned.

Example

#

This example returns a Unicode character for the given integer value.

SELECT NCHAR(99) AS 'NCHAR(99)',
       NCHAR(188) AS 'NCHAR(188)',
       NCHAR(248) AS 'NCHAR(248)',
       NCHAR(377) AS 'NCHAR(377)',
       NCHAR(650) AS 'NCHAR(650)'
Result:  1 record
NCHAR(99) NCHAR(188) NCHAR(248) NCHAR(377) NCHAR(650)
c ¼ ø Ź ʊ

Syntax

Syntax of the NCHAR function.

NCHAR(value)

value -- an integer value from 0 to 65355, or hex value 0 through 0xFFFF.

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.

Feedback
Guides


On this page
vsn 3.1