MySQL Bugs: #39935: MyODBC codepage problem

Bug #39935	MyODBC codepage problem
Submitted:	8 Oct 2008 14:58	Modified:	13 Sep 2012 13:39
Reporter:	obo tones	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	3.51	OS:	Windows (WinXP)
Assigned to:		CPU Architecture:	Any
Tags:	changing formating, codepage, MyODBC charset

Description:
Hi, I am new here so I am not sure about problem definition. I looked around but no solution has been found.

Situation: I'm try to copy data from db (firebird) on local machine with MS WinXP. Interface is used ODBC. I want to write to MySQL on external MySQL db. Everything works fine (numbers, and letters are copying OK) except special characters (like čťžýáíéšľ).

I tried to change charset in MyODBC 3.51 in option window but there is still the same result: changed characters.

I tried to use convert before putting data throught MyODBC to MySQL but no chance. I made 186 tests.

server side should be OK, because if I put this special characters to db directly (PHPMyAdmin, or via my simple script) it appers good.

I tried to spy ODBC but with no results. So I think that problem is somewhere in MySQL/ODBC Connector.

Please help me with this. Thanks a lot.

How to repeat:
To send it again.

Suggested fix:
no idea

Hi Obo and thanks for your report.

This is not enough for me to start doing anything... I can tell you, for now, that PHP is not unicode aware so probably there lies the problem, if not in MySQL server config. What you're describing sounds like double conversion is happening (ie. latin1 > utf8 > latin1).
For now, please try using MyODBC 5.1 which has much better support for MB charsets. Infor me of result.

I started with 5.01 version. It was the same and I downgrade to previous version of MyODBC (3.51) where is ablitiy to chage charset in config window.

Moments ago I tried reverse operation. I imported data to excel from my test table from the web via MyODBC, I putted there interpuncion and special characters that I need directly to db via PHPMyAdmin and result was diferent blablabla characters.

So it has to be in MyODBC. I know no software that can spy input and output ODBC. 

Last think that I can do is migrate to older version of MySQL, copy db there and make test again. Or any suggestions? 

Thanks a lot for you time.

Please consider trying Connector/ODBC version 5.1. This is the current stable version of the driver and includes Unicode support. If the problem persists, please include precise steps on how to reproduce it. If you have written a program, also include a small piece of the program the shows the problem or a complete example that shows the problem.

Obo, have you tried what Jess suggested?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I have the same problem. No solution. Please help. bemotic@gmail.com

Obo, Alex:

 [10 Oct 2008 1:17] Jess Balint

Please consider trying Connector/ODBC version 5.1. This is the current stable version of the driver and includes Unicode support. If the problem persists, please include precise steps on how to reproduce it. If you have written a program, also include a small piece of the program the shows the problem or a complete example that shows the problem.