ID: 45921 Updated by: [EMAIL PROTECTED] Reported By: ymagriso at gmail dot com -Status: Open +Status: Assigned Bug Type: MySQLi related Operating System: Windows XP/SP3 PHP Version: 5.2.6 -Assigned To: +Assigned To: mysql
Previous Comments: ------------------------------------------------------------------------ [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). ------------------------------------------------------------------------ [2008-08-29 07:08:26] ymagriso at gmail dot com As I stated in the original message the SET NAMES actually works fine as a workaround (no error and the character set is changed to "hebrew"). As for the list of available character sets: mysql> show character set; +----------+-----------------------------+---------------------+--------+ | Charset | Description | Default collation | Maxlen | +----------+-----------------------------+---------------------+--------+ | big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 | | dec8 | DEC West European | dec8_swedish_ci | 1 | | cp850 | DOS West European | cp850_general_ci | 1 | | hp8 | HP West European | hp8_english_ci | 1 | | koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 | | latin1 | cp1252 West European | latin1_swedish_ci | 1 | | latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 | | swe7 | 7bit Swedish | swe7_swedish_ci | 1 | | ascii | US ASCII | ascii_general_ci | 1 | | ujis | EUC-JP Japanese | ujis_japanese_ci | 3 | | sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 | | hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 | | tis620 | TIS620 Thai | tis620_thai_ci | 1 | | euckr | EUC-KR Korean | euckr_korean_ci | 2 | | koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 | | gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 | | greek | ISO 8859-7 Greek | greek_general_ci | 1 | | cp1250 | Windows Central European | cp1250_general_ci | 1 | | gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 | | latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 | | armscii8 | ARMSCII-8 Armenian | armscii8_general_ci | 1 | | utf8 | UTF-8 Unicode | utf8_general_ci | 3 | | ucs2 | UCS-2 Unicode | ucs2_general_ci | 2 | | cp866 | DOS Russian | cp866_general_ci | 1 | | keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 | | macce | Mac Central European | macce_general_ci | 1 | | macroman | Mac West European | macroman_general_ci | 1 | | cp852 | DOS Central European | cp852_general_ci | 1 | | latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 | | cp1251 | Windows Cyrillic | cp1251_general_ci | 1 | | cp1256 | Windows Arabic | cp1256_general_ci | 1 | | cp1257 | Windows Baltic | cp1257_general_ci | 1 | | binary | Binary pseudo charset | binary | 1 | | geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 | | cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 | | eucjpms | UJIS for Windows Japanese | eucjpms_japanese_ci | 3 | +----------+-----------------------------+---------------------+--------+ 36 rows in set (0.05 sec) mysql> The character set "hebrew" is there. As for your last request, the "my.ini" does not include any statement regarding the "character_sets_dir". Adding it as advised in MySQL documentation does not help in this case. ------------------------------------------------------------------------ [2008-08-28 21:25:12] [EMAIL PROTECTED] IIRC, the SET NAMES doesn't actually do anything with Mysql 5.0 on client side..I might be wrong though. :) Check that you really have it, run this in the mysql client: mysql> SHOW CHARACTER SET; And check your mysql config (my.cnf or whatever it's called in win32) that it has the proper path for the charsets. It should be in [mysql] section. (mysql manual might help? :) ------------------------------------------------------------------------ [2008-08-28 18:37:15] ymagriso at gmail dot com I un-installed PHP, downloaded the PHP installer again from another mirror and installed again. However, the version of the client was still 5.0.51a (and I am still encountering the same problem). Please, advise whether I am missing something. ------------------------------------------------------------------------ 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/45921 -- Edit this bug report at http://bugs.php.net/?id=45921&edit=1
