August 22, 2007 at 5:55 am
Hello All -
I need to set up a database with tables which should accept all Asia Pacific languages (Korean, Thai, Chinese). Can anyone share way of configuring database, tables, writing queries to accept these international characters, and best practices?
Thanks in advance!
Viking
August 22, 2007 at 6:04 am
nchar and nvarchar columns will have no problems storing these characters. However storing could be a problem. This will affect you if you have any clustered indexes set up on any of these characters. You will probably want to set the collation for the database/table to the most frequently used sorting order.
For queries much depends on whether you need to sort based on these columns. Same collation rules apply. Query tuning can get a bit painful if you have to connect tables with different collation orders.
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply