Edit report at http://bugs.php.net/bug.php?id=45921&edit=1
ID: 45921 Updated by: johan...@php.net Reported by: ymagriso at gmail dot com Summary: Can't initialize character set hebrew (path: C:\mysql\\share\charsets\) -Status: Assigned +Status: Feedback Type: Bug Package: MySQLi related Operating System: win32 only PHP Version: 5.2.6 Assigned To: mysql Block user comment: N New Comment: Please mind the last comments and test a more recent snapshot/release. Previous Comments: ------------------------------------------------------------------------ [2009-04-27 11:54:05] johan...@php.net Sorry, my bad, confused names, SET_CHARSET_DIR is the one i meant, but that isn't exported, checking whether there's a reason or just oversight. ------------------------------------------------------------------------ [2009-04-27 11:25:58] johan...@php.net Please use $db->options(MYSQLI_SET_CHARSET_NAME, 'C:\\MySQL5.0\\share\\charsets'); to properly set the charset path. ------------------------------------------------------------------------ [2008-11-21 19:21:07] paj...@php.net All mysql extensions use the same library. Assigned back to "mysql" and let them try to figure what's wrong here. ------------------------------------------------------------------------ [2008-09-01 20:28:34] ymagriso at gmail dot com I found a solution to the problem. The problem is related to php_mysqli.dll that comes with the PHP installer package. I downloaded another version of the DLL from MySQL website: http://dev.mysql.com/get/Downloads/Connector-PHP-mysqlnd/php_5.2.1-mysqlnd-5.0.1-beta.zip/from/pick I replaced the "faulty" DLL (that came with the PHP installer package) with the one I downloaded from MySQL website, then restarted the webserver and the problem was gone. I would recommend to check the php_mysqli.dll that comes with the PHP installer package. ------------------------------------------------------------------------ [2008-08-31 12:54:58] ymagriso at gmail dot com I just wanted to add another comment. I called the following queries via PHP using MySQLi: 1) show character set 2) show variables like "%character%" Surprisingly, I got exactly the same results as via "mysql" client. So, the problem seems to be related to the mysqli::set_charset(). I could not find anywhere in "php.ini" or "my.ini" (MySQL) that path defined ("C:\mysql\\share\charsets\"). My guess is that the path "C:\mysql\\share\charsets\" is hardcoded within the method in the MySQLi library (php_mysqli.dll). ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/bug.php?id=45921 -- Edit this bug report at http://bugs.php.net/bug.php?id=45921&edit=1