utf-8 encoding not working in 5.1.4 (works correct in 3.51.25)

utf-8 encoding not working in 5.1.4 (works correct in 3.51.25)

am 11.05.2008 01:19:09 von Marc Elser

Hi Jess and all the people working on the odbc/connector,

I use an external application which sends data in utf-8 to mysql through
mysql odbc connector.

When I use the old mysql connector 3.51.25 and take a look at the stored
table data, everything looks ok. All utf-8 characters like umlauts are
correctly displayed in my terminal (which is also set to utf-8).

When I install connector 5.1.4 and do the same, alle the multibyte utf-8
characters are not displayed correctly anymore. Instead of displaying
for example the correct utf-8 umlaut symbol, the table data shows
two-characters (or two bytes), so I guess 5.1.4 did not mark the table
data as utf-8 and I guess 5.1.4 tries to save data in latin1 (into a
utf-8 encoded table).

I hope this issue gets corrected in next release, because 5.x of course
should do the same as 3.x (backwards comptability) or else all existing
app's like the one I use would stop working correctly if they store data
in utf-8. As this is an external binary app I also have no possibility
to change anything to make it working with connector 5.x.

Thanks in advance for taking a look at this.

M. Elser

PS: If you need more data or want me to debug something don't hesitate
to contact me.


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