Re: [PHP-I18N] International characters look OK in PHP app, not in MySQL GUI

2009-10-14 Thread Michael R Boudreau
Thanks for this, Darren. It turns out that, although I had already explicitly set the character set and collation for the table I was updating/viewing, that wasn't enough. I reset the MySQL server variables to use utf8 for the default character set, then dropped and recreated the database, expl

Re: [PHP-I18N] International characters look OK in PHP app, not in MySQL GUI

2009-10-12 Thread Darren Cook
> The problem in the PHP app is that they don't sort in the correct order. For > ex., capital E with any accent sorts between A and B. That's a curious symptom. I've no suggestion, but the other information you didn't give was: a) do you have the mbstring extension installed (and if so, what is