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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: rr at gelsendata dot de
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2021 The PHP Group
All rights reserved.
Last updated: Tue Sep 28 17:03:37 2021 UTC