CA ERwin Data Modeler Workgroup Edition › The Administrator's Tasks › Specify Use of Foreign Characters With Microsoft SQL Server 2005

Previous Topic: Specify Use of Foreign Characters With Microsoft SQL Server 2000

Next Topic: Connect to the Mart

Specify Use of Foreign Characters With Microsoft SQL Server 2005

For Microsoft SQL Server 2005/2008, it is necessary to modify your registry settings to have certain foreign language characters in your models recognized.

To specify the use of foreign characters with Microsoft SQL Server 2005/2008

  1. Click Run on the Start menu.
  2. Enter regedit.

    The Registry Editor opens.

  3. Verify or add the following registry entry:

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\DB-Lib]

    "AutoAnsiToOem"="ON"

    "UseIntlSettings"="ON"

  4. Click File, Exit.

    Your configuration is set to recognize foreign language characters in your models.