php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #27087 CLI and CGI binary problem with mySQL and UTF8
Submitted: 2004-01-29 11:19 UTC Modified: 2004-02-04 19:17 UTC
Votes:3
Avg. Score:3.3 ± 0.5
Reproduced:3 of 3 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: rr at gelsendata dot de Assigned:
Status: No Feedback Package: MySQL related
PHP Version: 4.3.4 OS: Win32 (XPpro & 2Kpro)
Private report: No CVE-ID: None
 [2004-01-29 11:19 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-02-04 19:17 UTC] 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.


 [2005-09-15 10:50 UTC] etienne_botha at yahoo dot com
Latest  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip does not fix
 [2006-04-05 12:44 UTC] tobozo at phpsecure dot info
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
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 07 19:01:28 2024 UTC