Database Configuration for Unicode

Sybase 12.5 +

The pre-requisites for Unicode with Sybase are:

• Sybase Active Server (ASE) Version 12.5 or later. (Unicode support is NOT enabled for Version 12.0);
  
• Default character set for the Sybase Server needs to be "UTF-8".

To set this:

1. Make sure the Sybase SQL Server is not running. (Cancel it from the "Services" screen).
   
2. Run "Server Configuration" from the "Sybase" entry in the Task Menu bar, or run SYCONFIG.EXE directly;
   
3. Either Create a new Active Server or Configure an existing Active Server. (Selection is via Pushbuttons on the dialog box);
   
4. For either method, select the "Language" pushbutton;
   
5. Select the "Character Set" pushbutton;
   
6. Select the "Set Default" pushbutton;
   
7. Select "Unicode 3.0.1 UTF-8" from the list box.

If this entry is not available, you will have to add it. From the Character Set selection dialog box, select the "Add / Delete" pushbutton. Select the character set from the list box of those available. Select the "Add" pushbutton (or the "Add All" pushbutton to make all character sets available). Select OK. Once the default character set has been selected, select "OK" and "Exit". Start (or restart) the Sybase SQL-Server.