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?

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top