Re: Internationalized feeding of MySQL
| From: | Dennis Heuer | Date: | Wed, 19 Feb 2003 18:33:05 +0000 |
| Subject: | Re: Internationalized feeding of MySQL | ||
| Groups: | php.i18n | ||
| Request: | Send a blank email to php-i18n+get-463@lists.php.net to get a copy of this message | ||
Dear Spud and Gary -
Thanks for your replies, they got my mind thinking into the right direction...
But, first, one comment:
You should not send answers with CC because, Spud, your email I got two times and, Gary, yours I got
four times ;)
So, now, just to sum up:
If I set all my HTML pages and forms to working with UTF-8, all transfers in both directions should
be working fine. None of the involved software - means: (modern) browser, (apache) server, php and
MySQL - seems to make compromises except when doing fulltext searches in MySQL.
About the fulltext search:
I don't know about this particular problem but if you store the japanese keyword in a hash
table and then compare between hash table and your other tables then the comparison could work since
both the keyword and the db content are now formatted the same way by MySQL itself.
Just a thought.
Greetings
Dennis