From: Date: January 10 2005 4:32pm
Subject: myODBC 3.51.10, mySQL 4.1.8, UTF-8 and protocol issue ?
List-Archive: http://lists.mysql.com/myodbc/9770
Message-Id: <2d01493005011007322f59a68b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Hi List,

myODBC version: 3.51.10-1
mySQL version : 4.18-nt

We are having issue with a few fields from a 9millions big database
and we suspect myODBC to be the source of the
problem for the following reason.

We use myODBC in ASP and we when we just display the values with
error, in an UTF-8 encoded page, only some of the
characters are not displayed correctly, with ?? in place of the
correct value. Like "Hello W??rld" for instance.
However, when we do the same query and look at the result in mySQL
Query Browser, the value is displayed correctly. The
datas in the table are imported from a text file using the LOAD DATA
INFILE command. The server, database, and all
fields character set is UTF-8, always.

Our idea, after some research, is that mySQL Query Browser might use
the new binary protocol, whereas myODBC does notfor
sure. Our question is : could this be it, and what should we do if it is ?

Thank you for your help!
CheHax