[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