>>>The data types with N prefix (nchar, nvarchar and ntext) are used to store the Unicode data but each chracter uses 2 bytes to store.
>>
>>I know that data types with the N prefix stores unicode characters. Thanks for confirming that data types with N prefix consumes 2 bytes for every character. Do you know of any advantage of using data types with the N prefix over the data types without the N prefix? The only advantage I can see is if the app is mutilingual.
>
>It's not a question of advantage but what type of data you've to store. You can only store Unicode data in data types with N prefix but you'll pay for that with extra storage space used.
Do you use data types with or without the N prefix?
Einar
Semper ubi sub ubi.