OK I have a really basic question I hope. How do you have UTF8 data saved
to a MySQL 4.0 database and then extract it and put it back into UTF8? Do I
have to use the mb_convert_encoding($str, EUC_JP, UTF8) in PHP before the
insert and the reverse after the select? I'm using UTF8 on the web page but
the 4.0 version of MySQL doesn't support it ( Idiot me tested it in 4.1 not
thinking so the whole project is designed in UTF8).
I think you'll be better off using MySQL 4.1 (still in Alpha),
or the latest version of PostgreSQL, both of which natively supports UTF-8
character set.
As a side note: often it appears possible to forcefully use UTF-8 in a table that is
created to store strings of a character set different than UTF-8 because it actually
work without any error, but it would result in some weird behaviour when you use SQL
string manipulation functions / operators ("LIKE" / regex comparators) and FULLTEXT
indexes with such a mismatched setting.
In other words, you can use UTF-8 unless you are planning to use any of these features.
It's anyway discouraged though.
Moriyoshi
-- PHP Internationalization Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
