Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on SQL Server Backup and Recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.