difference between datatypes in sqlserver7.0

[shree]

hi all,

i have one doubt regarding to sql server7.0 data types.

what is the difference between varchar and nvarchar.

thank you in advance.

[Kid Charming]

NVARCHAR stores data in Unicode. You only get half the space of a regular VARCHAR, because you're using 2 bytes per character, but you can properly store characters that need 2 bytes.

[shree]

thank you sir,


means the functionality is same. both are for same purpose, both will allow numbers and characters. am i right sir??

thanks alot.

shree

[Kid Charming]

Yes, but NVARCHAR (and the other N types) also allows you to properly store 2-byte Unicode characters, like Greek, Turkish, etc. letters.