It's in the beginning stages at this point. Currently, I have a SQL Server
database that uses a collation
of SQL_Latin1_General_CP1_CI_AS
. As I understand it, there is a requirement in the works where multiple languages will need to be supported, specifically languages like Spanish, French, Portuguese, maybe Italian. Dutch and German are possible. Eastern Asian languages like Chinese and Japanese are also likely.
The database platform will either be SQL Server 2008, SQL Server 2012, or SQL Server 2014.
This seems like a big undertaking and I'm not sure where or how to start. How do I design a database to support multiple character sets
?
Example:
Can dbo.Foo support all these languages listed aove, or must I have a different schema for each collation
? (I.e. Eng.Foo, Jp.Foo, Fr.Foo) If it's the latter, that means I'll have multiple tables with identical column names but different data.
Any advice on where to start with this task?
Thank you.
Use a UTF-16 collation from the beginning. UTF-16 was designed specifically for this purpose.
For more detailed information, I recommend this article (second half) and this page from the MSDN documentation.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments