10-05-2005, 07:50 AM
i have one doubt regarding to sql server7.0 data types.
what is the difference between varchar and nvarchar.
thank you in advance.
10-06-2005, 02:57 AM
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.
10-06-2005, 09:04 AM
thank you sir,
means the functionality is same. both are for same purpose, both will allow numbers and characters. am i right sir??
10-06-2005, 05:41 PM
Yes, but NVARCHAR (and the other N types) also allows you to properly store 2-byte Unicode characters, like Greek, Turkish, etc. letters.