Where I’m @

20060407

Character Sets in MySQL
A rogue app written by one of our enterprising developers before he was my enterprising developers was in PHP with a MySQL db behind it. Ran initially on Apache on Windows (WAMP?) and was migrated to IIS (WIMP) along with his chain of reporting. Curiously, an error message appeared in the app that had not been there on his local box, to wit “File 'path\to\mysql\share\charsets\?.conf' not found (Errcode: 2); Character set '#33' is not a compiled character set and is not specified in the path\to\mysql\share\charsets\Index' file.” Many people have seen this error, though no recommendation worked in our situation. UTF8 is indeed one of the server's character sets, and utf8_general_ci one of the available collations. The only thing that ended up working was adding a line to the MySQL config file (my.ini, in path\to\mysql\) explicitly setting the default-character-set value to latin1 and restarting the MySQL daemon. Since we use a lot of international characters in our work, we'll just have to remember to set the character set and collation on all the dbs we create, or possibly look into moving from 4.1.x up to 5.

posted by Tk at 17:16 • • sealed in amber