July 10, 2012 at 11:36 pm
why nvarchar using in sql?
July 10, 2012 at 11:54 pm
To provide full character support, including double byte characters.
July 11, 2012 at 12:12 am
artcvmna (7/10/2012)
why nvarchar using in sql?
I usually use it to support unicode data string which varchar does not support e.g. you can use it to store multilanguage data in database.
For more information have a look on below article.
http://msdn.microsoft.com/en-us/library/ms186939.aspx
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 11, 2012 at 12:36 am
Data types like varchar, char uses ANSI encoding technique to store character.
However to handle wide variety of languages in the world Unicode encoding mechanism had been developed. Unicode data types are preceded with an "n". e.g. nvarchar, nchar
Unicode standard uses 2 bytes to represent each character which is twice as much space as ANSI uses.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply