I am using MySQL 4.1.22. and PHP 4.4.4.
Now, when I add the following 2 lines of code, mysql_query() works perfectly with utf8 charset:
mysql_query("SET CHARACTER SET utf8", $db);
mysql_query("SET NAMES 'utf8'", $db);
However, results for mysql_fetch_array() appears like (????????).
I'd search google for a solution but was unable to find one. If it is really a bug with mysql_fetch_array(), how can I rewrite mysql_fetch_array() to use mysql_query() instead?
Is there a utf8 bug with mysql_fetch_array()
Moderator: General Moderators
- AKA Panama Jack
- Forum Regular
- Posts: 878
- Joined: Mon Nov 14, 2005 4:21 pm
MySql 4 isn't that great on UTF8 support. You may not have the approriate character installed for MySql to store and retrieve the data properly.
http://dev.mysql.com/doc/refman/4.1/en/ ... ation.html
MySql 5 remedied this problem has very robust UTF8 support. If you can upgrade your server you should.
http://dev.mysql.com/doc/refman/4.1/en/ ... ation.html
MySql 5 remedied this problem has very robust UTF8 support. If you can upgrade your server you should.