Hello everybody,
I have just installed a MySQL Server 4.1.7 on my machine (Win XP SP2 de) to try out my software with the new version. Everything works fine with 4.0.x and I store all data UTF-8 encoded into the tables. This produces a wrong sorting order, but that's not a big issue.
Now I have copied all tables with the latest MySQL Administrator to the 4.1 server. I don't exactly understand what's going on there, but as far as I could test it (SHOW VARIABLES LIKE "char%"), there are multiple character set settings which have inconsistant values (some are "latin1", some are "utf8"). Is this producing my Unicode crap output? In MySQL Query Browser, all values appear UTF-8 encoded. It's not the correct characters like Ã, Ã or Ã, but their UTF-8 represantation. I know that and that's OK. But PHP shows some of the characters right and others wrong. I haven't found any system behind that.
Changing that encoding doesn't really work. Neither sending manual queries to set "latin1" nor adding connection parameters (which are consistantly forgotten on the next programme start) show any effect. The variables don't change and the output remains crap.
Can anyone help me setting it all to EITHER latin1 OR (preferrably) utf8, so that I can continue testing my software with MySQL 4.1 and one day consider that server "stable" for myself?
If there is a problem with MySQL Administrator or Query Browser, please tell me so that I can stop using them and go back to the shell client. But I fear this will cause trouble because the online documentation (which I'm still not quite a fan of) shows an incorrect syntax for the "SET characterset" command.
-- Yves Goergen <[EMAIL PROTECTED]>
BlackBoard Internet Newsboard System --> blackboard.unclassified.de Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
