what is the difference from varchar... 2

[edgarasm]

Hi,

what is the difference from varchar to nvarchar and text to ntext beyond length? What situation should I use one or another?


thanks very much for any explanation!

regards

 

[clarkin]

"char is a character in a given server dependent character set, nchar is a unicode character. If you want to support multiple languages/character sets, nchar/nvarchar is the way to go."
(above googled)

As I understand it, the unicode character coding takes up more room (so in SQL Server you can store half the amount of characters (max) in nchar compared to char), but can represent a lot more characters - such as arabic/chinese symbols.

This MSDN page covers it quite well:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_03_6voh.asp

char encoding has 256 different characters it can represent, nchar uses twice the space but can represent 65,536 different characters.


Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].