Knowledgebase

Search:     Advanced search

Setting SQL Server Unicode Options

Article ID: 264  |  Last updated: 23 Dec, 2014

Note: This information only applies to Seapine License Server 3.0 and later.

If you use a SQL Server 2000 database with the Seapine 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.

Mac OS X

  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.

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.
Article ID: 264  |   Last updated: 23 Dec, 2014
Tags
Unicode SQL Server

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