Knowledgebase

Search:     Advanced search

Setting SQL Server Unicode Options

Article ID: 264  |  Last updated: 09 May, 2017

If you use a SQL Server 2000 database with the Helix ALM License Server, you must set specific DSN options to support Unicode.

Windows

  1. Choose Start > Settings > Control Panel.
  2. Double-click Data Sources (ODBC).
  3. Click the System DSN tab.
  4. Select a SQL Server DSN then click Configure.
  5. Click Next three times.
  6. Make sure the Perform translation for character option is selected for the DSN.
  7. Click Finish.
  8. Click OK to close the ODBC Microsoft SQL Server Setup dialog box.
  9. Click OK to close the ODBC Data Source Administrator dialog box.

Linux

  1. Open the HTTP-based OpenLink ODBC Administrator in a Web browser.
  2. Expand the Client Components Administration item.
  3. Expand the Configure ODBC Data Sources By Form subitem.
  4. Click the Configure ODBC Data Sources subitem.
  5. Select the SQL Server DSN that uses OpenLink SQL Server Lite Driver (multi threaded).
  6. Enter the following value in the Database Server field:
      -C UTF-8 -N 0 -O 1
  7. Click Update to save changes.

Mac (License server 2015.1 and earlier only)

  1. Open the ODBC Administrator.
  2. Click the System DSN tab.
  3. Select a SQL Server DSN then click Configure.
  4. Select the Connection tab.
  5. Select UTF-8 from the Character set list.
  6. Clear the Disable character set translation option.
  7. Click Finish.
Article ID: 264  |   Last updated: 09 May, 2017
Tags
Unicode SQL Server

Prev   Next
License Server System Requirements     Migrating from the 32-bit Helix ALM License Server to the 64-bit...