Even if it's still a server issue, I think people from this list might better know how to fix the following:
I have some issue with the accentuated characters in MySQL: I don't have any table or column named using accentuated characters, I'm only talking about data. I didn't dump from previous data for now as the MySQL server didn't complain about anything but the authorization in the log (new password, but I want to be able to use Cocoa MySQL, so until a new release, I won't fix this). And I tried on my local machine and I'm not fully satisfied;)
When I look at the content of the data, from Cocoa MySQL, I got the correct display with the accentuated characters When I look at the content of the data, from phpMyAdmin, I got a wrong display with the accentuated characters (é displays as é)
and through the web application in a browser display: either ?? (?? or é in source view)
The data was entered in the database using a web application using connector/J with "useUnicode=true&characterEncoding=utf8" parameter. And this was in a MySQL 4.0.xx (the one included in 10.3)
So I've got a couple problem "defining" the issue as Cocoa MySQL display the data correctly and not phpMyAdmin...
So if anyone has a pointer or a cure;)
Thanks for your help... hopefully for Apple, there's mailing list with nice people who knows how to correct Apple's "weakness":)
Xavier |