Configure a Microsoft SQL Database for Double-byte Languages

If you are localizing to a double-byte language (such as Japanese or Chinese), follow this procedure:

  1. Start with a double-byte database (files with -dbt suffix) that is NOT live.

  2. Open a query browser like SQL Server Management Studio

  3. Run projects/users/public/dt/database-update/sqlscripts/utilities/mssql-generate-script-to-change-collation.sql

    • Set the schema (@scm) to the schema, which is normally afm

    • Set the collation name (@cn) to the preferred collation

  4. Paste the results of the query from step 3 into a new query editor window and run it

  5. Start web central

  6. Open the Database Update Wizard.

  7. Run the script, projects/users/public/dt/database-update/sqlviews/re-create-sql-views-mssql.duw