Skip to Content

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

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.

odbc.png (726.8 kB)
odbc15.png (228.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2013 at 09:49 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2013 at 04:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.