MySQL Forums
Forum List  »  Connector/ODBC

MySQL and UTF-8 problem is being ignored
Posted by: Rafi q
Date: August 13, 2005 12:19AM

For over a year now, every singel post of this subject is being ignored.
Here are just a few samples:

http://forums.mysql.com/read.php?37,25456,25456#msg-25456
http://forums.mysql.com/read.php?37,17901,17901#msg-17901
http://forums.mysql.com/read.php?37,14022,14022#msg-14022
http://forums.mysql.com/read.php?37,2767,2767#msg-2767

Does anyone have any Idea why?

Here is a post that I've sent to both win32 and MyODBC mailing list:

Hello

We have a problem using UTF-8 with MySQL running on windows.

I would like first to start with some background…

About 4 or 5 years ago we’ve developed an ASP based, Multilanguage solution on MySQL DB.
It was hosted on a Sun Cobalt box running some version of Linux and Apache as the web server.

I was not involved in the installation of the box as it was sold as a “Web Appliance“solution and was preconfigured including the MySQL.

The solution we’ve developed was using UTF-8 as the Encoding throughout the site (every single page and form). We did not had to configure anything on the server for it to work and the data was stored (and retrieved) at the right language that it was saved in, regardless of the language that was used. We could support every single language and some time more then one language at a time with one interface and one encoding type.

Again, all this was over 4 years ago. And it was working very well for us.

About a year ago, some of the requirements of the project called for a change in the OS to a Windows base one.

Since then we can not save any non English based language at all, it all being stored as “????”

For reference I would like to mention that with the exact same configuration when we use PHP pages to store and retrieved data it would work fine.

In no place in the MySQL web site we could fine any indication or acknowledgment for this problem. But on some sites we have found some hints that it possibly a problem with the MyODBC Driver. Again, we could find no indication or acknowledgment for this problem on the MySQL web site. While other sites clime that there in no support for Unicode in MySQL at all and that it should be coming in version 3.53 of the MyODBC Driver which in now is probably not coming as a newer version (5) is now in alpha stage. (again, with no mentioning of the UTF-8 problem).

What exactly are we missing here?
Was there ever an official support for UTF-8 in MySQL; in any of the versions or it was just a glitch that it worked for us under Linux?

And if there was, is it just the windows version that does not support the UTF-8?

In any way, I know I’m not the only one to have this problem as I have found thousands of pages/posts on the web (including the MySQL site) for the same problem but with no real answer. Why is the MySQL teem is ignoring this very serious problem for years now?

I would appreciate any response as at this stage we are so disappointed and hopeless that we are looking into replacing the MySQL.

Thanks,
Rafi.

Options: ReplyQuote


Subject
Written By
Posted
MySQL and UTF-8 problem is being ignored
August 13, 2005 12:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.