Edit report at http://bugs.php.net/bug.php?id=45921&edit=1
ID: 45921
Updated by: johannes@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] johannes@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] johannes@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] pajoye@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