[support] Import HTML, XLS, UTF and MySQL
Fred Jones
fredthejonester at gmail.com
Tue Mar 4 15:40:21 UTC 2008
>> The only PROBLEM is that there are UTF characters (Hebrew to be
>> specific) in the data and when I run my PHP script, it converts them to
>> garbage question mark signs. I have PHP 5 and MySQL 5 on my Win 2K system.
>>
>
> You may want to look at PHP functions htmlspecialchars_decode,
> html_entity_decode and utf8_encode.
Thanks for your help. The answer was to add:
mysql_query("SET NAMES utf8");
to setup UTF in my PHP code.
Thanks for your help!
More information about the support
mailing list