#27087 [Com]: CLI and CGI binary problem with mySQL and UTF8

ID: 27087 Comment by: tobozo at phpsecure dot info Reported By: rr at gelsendata dot de Status: No Feedback Bug Type: MySQL related Operating System: Win32 (XPpro & 2Kpro) PHP Version: 4.3.4 New Comment: This is not a php problem, this is a (very annoying and long lasting) mySQL bug : http://bugs.mysql.com/bug.php?id=312 http://bugs.mysql.com/bug.php?id=276 solution : use pgSQL Previous Comments: ------------------------------------------------------------------------ [2005-09-15 10:50:19] etienne_botha at yahoo dot com Latest http://snaps.php.net/win32/php4-win32-STABLE-latest.zip does not fix ------------------------------------------------------------------------ [2004-02-04 19:17:46] sniper@php.net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2004-01-30 12:26:42] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2004-01-29 11:19:44] rr at gelsendata dot de Description: ------------ We are stuck with the following: We have an application running on PHP 4.3.4 that utilizes a mySQL DB with UTF8 as default charset for the tables, and runs on Apache 2.0.45. PHP is configured using the Apache2 SAPI and everything works well. We also have some PHP scripts for the CLI binary that has to access the DB, too. We use a self-written DB class, which is very basic. When trying to connect to the DB the following error occurs: ----------- File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file ----------- The connection is not established and the script aborts, whereas a connection with the Apache2 SAPI version works fine and works as expected, regarding UTF8. But since mySQL 4.1 the .conf files are deprecated and XML files are used instead. After consulting several forums and newsgroups we assumed this might be a bug. A research in the bug datebase did not bring any result. Any help with that issue would be greatly appreciated. Many thanks in advance, sincerely Rüdiger Reinhardt, GelsenData GmbH Reproduce code: --------------- // concerning the nature of this problem, I suppose the // reproduce code might be mandantory. $this->connection = mysql_connect($server, $user, $password); Expected result: ---------------- A connection to the DB server should be established. Actual result: -------------- The above error is printed and the script aborts. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27087&edit=1