Japanese and English in same Database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Japanese and English in same Database

I hope someone out there can help me out with this as I’m new to supporting multiple languages. My boss has asked to design a database to handle both Japanese and English records for a new corporate website. The SQL box this will sit on exists already with the following collation: SQL_Latin1_General_CP1_CI_AS – not sure if that’s relevant but other postings have mentioned collation. So my question is: what do I need to do to handle these records in the same database? I know that all columns need to be nvachar, or nchar etc but the actual setup needed I’m clueless on. Thanks
Not only the collation. you need to address the column type as well. YOu need to have nvarchar nchar ntext instead of varchar,char,text. http://www.sqlservercentral.com/columnists/dasanka/globilizationinsqlserver.asp —————————————-