Convert English language database into Japanese
I have an English language database that needs to be created in Japan. The approach we were going to take was to have our affiliate in Japan create the database and restore the database from a backup we would provide. How would Japan convert the English language database into Japanese?
You can use backup and restore to create the database and then change the collation for the database as well as columns within the database. Also, make sure that you used the nchar, nvarchar and ntext datatypes, so you can store Unicode data.
The article, Using Unicode Data can help you find more information on Unicode.
Also, check out this Expert Answer that provides more detail on changing collations.
Do you have comments on this Ask the Expert Q&A? Let us know.
This was first published in April 2005