August 21, 2006 at 10:49 am
I need to build a SQL server db that supports Unicode data from several different languages like German, French, Spanish, Chinese, Arabic, Russian, and of course, English. I have to be able to store 2 types of ASCII, UTF8 and UTF16 which will reflect on the performance.
In this case, I guess the only choice I have is to use Unicode data type nvachar, ntext, etc.
Because of these data types, I already have huge concerns expressed that this will increase the storage space for the only English (ASCII 7) customers.
Is there some other path I could take?
August 21, 2006 at 9:33 pm
In SQL Server 2000 and above you can do column level collation, and there are six Chinese in SQL Server so using both Unicode and ASCII is asking for character conversion. Hardware is very cheap now. Try the lins below for SQL Server collations list. Hope this helps.
http://msdn2.microsoft.com/en-us/library/ms144250(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms180175(SQL.90).aspx
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply