Error "Could not load code page for requested charset" message when connecting to Sybase. (54614)

While connecting to a Sybase database with roman8 as charset, the following  message occurrs immediately, after clicking the CONNECT button in the Create a Connection window

Database Error was returned: "Could not load code page for requested charset".

WORKAROUND:

1. Connect to the Sybase database. Check if â€enable unicode conversionssssââ†is set to 1 by running sp_configure.

2. If not, set it to 1 by running the command

sp_configure "enable unicode conversions", 1
go

Ã

3. Connect via Toad for Data Analysts (TDA) using the other charset

STATUS:

Â

Waiting for a fix in a future release of Toad for Data Analysts.

WORKAROUND:

1. Connect to the Sybase database. Check if enable unicode conversionssssââ†is set to 1 by running sp_configure.

2. If not, set it to 1 by running the command

For 3.0, development intend to change where the character conversion takes place.  Many applications do the character conversion on the client side while the TDA option tries to perform the conversion on the server (before data is sent to the client).