Skip to Content
author's profile photo Former Member
Former Member

Double-byte characters not saving properly in DB

Hi, we are currently upgrading our app server from Win2003 to Win2008 64bit. ODBC driver was also updated from Sybase System 11 to Adaptive Server Enterprise. We installed Sybase Adaptive Server PC Client 12.5.4 GA with ODBC driver version 12.05.01.510. Our VB6 application is now running in Win2008 64bit and able to connect to our existing Sybase DB via DSN. Double-byte characters (Korean) is OK when retrieved and display in the application.

Our issue is the correctly displayed Korean characters are not properly saved in the DB. They are saved as "?" per Korean Character. We already tried changing the connection string not to use DSN and specifying charset, issue still exists. Can somebody advise us on what to check for proper data saving. Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 25, 2014 at 01:56 PM

    Hi,

    This all depends on your ASE. What is your ASE default charset? Get the output of sp_helpsort.

    If your ASE default charset isn't some type that can hold Korean double byte characters the ASE will save them as ??? and if you look at the binary you will usually see A0 in the beginning. For other tools to see the characters correctly you need to specify the client character in the connection string.

    If your ASE charset is a utf8 default then the other tool you are using to see them has a different default character set so you need for the other client to specify a client charset to view them correctly in isql you would add -Jutf8 in the connection string.

    Thanks,
    Dawn

    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.