RE: Unicode (UTF-8) question

Connector 3.51 have no support for Unicode. You must wait for 5.0 connector
(stil alpha ....)

I wait almost 1.5 year for this, but boys from MySQL AB have no reason to
rush in this field of development ...Now I work in MS Access again,
costumers dont want to wait anymore ...

-----Original Message-----
From: Daniel Levy [mailto:daniel@xxxxxxxxx]
Sent: Sunday, January 29, 2006 11:23 AM
To: myodbc@xxxxxxxxxxxxxxx
Subject: Unicode (UTF-8) question


Hi,

I need a database for keeping UTF-8 encoded text. I can see the data in the
correct format (Chinese, Spanish, etc.) using the Query Browser, but when I
run a query from my application, the text displays differently (I think its
ANSI).

I have tried setting the character set of the table to utf8, and the
specific column character set to utf8. I've also tried configuring the
ODBC's Connect Options to 'set names utf8'; I've also checked options 'Don't
Optiimze Column Width', 'Return Matching Rows', and 'Read Options >From my
.cnf'.

I'm using mysql-5.0.18 and mysql-connector-odbc-3.51.12. I'm developing with
Delphi 5, using TNTware controls (Unicode).

Can somebody please give me any clues? Any advice will be greatly
appreciated.

Thanks in advance,
Daniel Levy

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx