#42297 [Opn]: mysql_fetch functions return ? instead of utf8 chars other than latin1

ID: 42297 User updated by: bmilosavljevic at gmail dot com Reported By: bmilosavljevic at gmail dot com Status: Open Bug Type: MySQL related PHP Version: 4.4.7 New Comment: I think I 've found the solution! This bug is due to MySQL, I think. If the following sql query is executed: SET CHARACTER SET utf8 (without ; is recommended) immediately after establishing a connection, the problem is solved, at least for me! Even more suitable query would be SET NAMES utf8, because connection's query strings are also submitted to the server in utf8. <?php $link = mysql_connect('localhost', 'database_username', 'database_user_pwd'); if (!$link) { die('Could not connect: ' . mysql_error()); } if (!mysql_select_db('database_name', $link)) { echo 'Could not select database'; exit; } //could be also SET NAMES utf8 $sql = 'SET CHARACTER SET utf8'; $result = mysql_query($sql, $link); ... ?> and instead of ... any query executed should return proper utf8 characters. Check this please in your environment! Previous Comments: ------------------------------------------------------------------------ [2007-09-24 14:10:44] dev at unleashedmind dot com Confirming that this bug exists. ------------------------------------------------------------------------ [2007-08-14 16:07:27] bmilosavljevic at gmail dot com Description: ------------ mysql_fetch functions return question marks (?) instead of utf8 chars (other than latin1). Tested on linux production server and on local windows developer server as well. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42297&edit=1