|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2008-08-26 12:01 UTC] ymagriso at gmail dot com
Description:
------------
I have Apache 2.2.9/PHP 5.2.6 and MySQL 5.0.67 installed on Windows XP/SP3.
Apache is installed in the following path: "C:\Apache2.2".
PHP is installed in the following path: "C:\PHP5".
MySQL is installed in the following path: "C:\MySQL5.0".
I am running the PHP script below and getting the error specified below. I could not find anywhere in the documentation how to troubleshoot this error.
Note, that when I connect with mysql as a client and check the "character_sets_dir" it shows the correct one:
mysql> show variables like "%character%";
+--------------------------+-----------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\MySQL5.0\share\charsets\ |
+--------------------------+-----------------------------+
8 rows in set (0.00 sec)
mysql>
Therefore, I assume that the problem is not related to MySQL configuration, but to "MySQLi". However, the documentation does not show how to change the "character_sets_dir" for MySQLi.
(Also, the documentation advises:
"Note: This is the preferred way to change the charset. Using mysqli::query() to execute SET NAMES .. is not reccomended."
However, SET NAMES works fine as a workaround to the problem.)
Reproduce code:
---------------
$db = new mysqli('host', 'username', 'password', 'database');
if(mysqli_connect_errno())
{
printf("Error: could not connect to database! Please try again later.\n");
return;
}
if(!$db->set_charset("hebrew"))
{
printf("Error: could not load character set hebrew - %s\n", $db->error);
}
Expected result:
----------------
Character set of DB is changed to "hebrew" (and no error is shown).
Actual result:
--------------
I am getting the following error message:
"Error: could not load character set hebrew - Can't initialize character set hebrew (path: C:\mysql\\share\charsets\)"
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 13:00:01 2025 UTC |
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).