Thursday, 8 December 2016

N is used to specify a unicode string

N is used to specify a unicode string.

In your example N prefix is not required because ASCII characters (with value less than 128) map directly to unicode.
However, if you wanted to insert a name that was not ASCII then the N prefix would be required.

Below 
​​

Select N'Wahi','Wahi'

No comments:

Post a Comment