Creating Databases for Double-Byte Languages for Microsoft SQL

Unlike Sybase and Oracle, Microsoft SQL Server cannot support both single-byte and double-byte language strings in the same database (when data types of both CHAR and VARCHAR are used, as is the case for ARCHIBUS). For this same reason, SQL Server cannot support strings from more than one double-byte language. For each individual double-byte language, a separate database is needed.

To create the required databases:

  1. Create the database for the double-byte language. See Creating the MS SQL Database.
  2. For each individual double-byte language, before running the Database Update Wizard, do the following:
    1. Change the machine locale.
    2. Restart the computer.
    3. Select the correct collation name when creating the database from the SQL Server Enterprise Manager:

    • Korean: "Korean_Wansung_CI_AS"

    • Triditional Chinese: "Chinese_Taiwan_Stroke_CI_AS"

    • Simplified Chinese: "Chinese_PRC_CI_AS"

  3. When running the Database Update Wizard, select "Asian" on the third screen.