Sybase ASE 15 ODBC driver doesnot have the option of Translate as in Sybase 11

[former_member294055]

When I try to use the ODBC drivers for Sybase ASE 15, to import the data to MS Excel, the Arabic characters in the Database are displayed as "?".

But, when I use the ODBC drivers for Sybase ASE 11, the data is correct.

The Characterset for database is CP850.

Please find the attached screenshots.

• The ODBC.png shows the Advanced tab for Sybase 11 ODBC drivers.
  • Here, when we use the translate option and select the "MS Code Page Translator" option, the data is correct.

• The other one shows the Advanced tab for Sybase 15 ODBC drivers.
  • Here, the translate option is not available, so what is the alternative for this?

Please let me know.

[Former Member]

Hi Pranav,

Robert is on the correct track. Also, what exact version of ASE ODBC Driver? Sound like older 15.0 version.  Changes were made in the charset translation/conversion/handling since early 15.0 version - on ASE ODBC 15.7 version there is more flexibility.  However, in using cp850 to store your characters - what are the column  data types?

Cheers,

-Paul

[Former Member]

charset CP850 is not multi-bytes charset !

on ODBC drivers for Sybase ASE 11, it do not do translate at all; you see correct Arabic character since no translation between client and server !!

on ODBC drivers for Sybase ASE 15, it did translate by default; I will suggest you to try to enter 'set char_convert off' on Initialization String of Advanced Tab, to force no translation between client and server to see if you can get  correct Arabic characters !!

HTH ! Thanks !!

Regards,

Robert Chu