> 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 the internal_encoding, and the other settings)? b) do you have the intl extension installed (and, again, what settings)? c) what is the server's locale setting? The first two you can get from a phpinfo() page. For the 3rd I think $_ENV["LANG"] is it, or this should confirm it: print_r(setlocale(LC_ALL,"0")); Also take a look at http://jp.php.net/setlocale and try setting "en_US.UTF8" explicitly at the top of your script. The comments say Mac requires "UTF-8", so you might also want to try: setlocale(LC_ALL,Array("en_US.UTF8","en_US.UTF-8")); (untested) Darren P.S. On the MySQL side have a look at the collation setting of the database. -- Darren Cook, Software Researcher/Developer http://dcook.org/gobet/ (Shodan Go Bet - who will win?) http://dcook.org/mlsn/ (Multilingual open source semantic network) http://dcook.org/work/ (About me and my work) http://dcook.org/blogs.html (My blogs and articles) -- PHP Unicode & I18N Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php