What is the N string prefix in SQL Server?

Question

Khushi Singh · Answer

In SQL Server, an N string prefix is used to distinguish between Unicode and non Unicode strings. It also helps in making sure that the string is of unicode that is NVARCHAR rather than non unicode that is VARCHAR. This is useful where there are large amounts of data that contain multilingual, or other characters not normally included in ASCII chart.
Key Points:
N Prefix:
The N stands for “National” or “Unicode”.When used, it will be treated as Unicode; it is used in an NVARCHAR column or variable/format to store it.
and 
Usage:
Put the N before the string literal in SQL.
Example:
SELECT N'Hello World';  -- Unicode string
Hope it helps!

forum

What is the N string prefix in SQL Server?

Sandra Emily

Can you answer this question?

1 Answers

Liked By