Extended characters not translated properly using ADO

Posted on 2006-04-06
Last Modified: 2008-02-01
I have a Visual Basic (6.0 SP6) application using ADO (2.7) to connect to a Sybase database (12.5).  The application recently upgraded to be run on a Windows XP (SP1) environment, using the Sybase ODBC driver.   Doing a regular SELECT statement, if the field contains an extended character, for example: café, when I look at the ADO Recordset, the text comes back as cafÅ.

We did not have this problem running the same application on Windows 2000, using Sybase ODBC driver

People are saying that it's a codeset issue, but I'm thinking it's an ODBC driver issue.   Has anyone faced this issue before, and what can be done to resolve it?

The worst case scenario is that I force the text to convert the extended characters properly, but that's the last thing I want to do.

Thanks in advance,
Question by:TitoBob
    LVL 7

    Author Comment

    After digging through several newsgroups, I found a fix:  Changing the charset of my ODBC DSN to iso_1.

    Admin, please close out this question.

    LVL 29

    Expert Comment

    Please post to the Community Support TA and ask for a refund.

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now