Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:24285
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
DomainKey-Status: good
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=o7V9+TzS1i8kqwFbbz59dYYDJ7NJ6pzxBvFMJXDmLXACFCimxs8tIiuGxhS+jkRYjLFwj6VX/YmNAVBEK3XN005G2/5TO1T2wd5n3gr3jSDd2GRagujT0s7L0e1tLhRn2HVSbVCF39RSjHbgIy7mp7Ncm94tw1boFQesomRsaQ4=
Message-ID: <dc2522540607060901i5ec70f5bs59bd8bf39c3b9e6c@mail.gmail.com>
Date: Thu, 6 Jul 2006 12:01:22 -0400
To: "Antony Dovgal" <antony@zend.com>
Cc: internals <internals@lists.php.net>
In-Reply-To: <44AD307D.6020908@zend.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <dc2522540607060836h56ba1aacsb5a94958385d6eeb@mail.gmail.com>
	 <44AD307D.6020908@zend.com>
Subject: Re: [PHP-DEV] PATCH - Charset in ext/mysql
From: olivier.hill@gmail.com ("Olivier Hill")

Hello Antony,

I've realized 5 minutes after posting that I would receive an answer like this.

I am aware that this is a bugfix only branch, but for us this was a
bug. We were moving to new servers compiled against MySQL 4.1 libs and
not the bundled ones with PHP. With this move, things got from latin1
to utf8 and since PHP 4 doesn't really care about Unicode, we had to
come up with this fix. Looking at the comments in the docs on php.net,
we were not the only one with this problem. [1]

I do not really care it the patch makes it to the core, I just wanted
to post it so other people having to deal with PHP4 and newer MySQL
versions can use this trick. In our case, MySQLi wasn't an option. We
will be upgrading to PHP5 shortly on our production servers, but in
the meantime this is an easy fix.

Sincerely,
Olivier

[1] http://ca.php.net/manual/en/function.mysql-client-encoding.php

On 7/6/06, Antony Dovgal <antony@zend.com> wrote:
> On 06.07.2006 19:36, Olivier Hill wrote:
> > Hello internals,
> >
> > Attached is a patch against PHP_4_4 allowing to specify a charset when
> > talking to MySQL using ext/mysql and client libraries that come with
> > MySQL >= 4.1.13 (the default being utf8).
> >
> > This was mainly tested with latin1. To test, add an ini entry like this:
> >
> > mysql.default_charset = "latin1"
> >
> > Any constructive comments on the patch would be appreciated.
>
> IIRC such patch has been already discussed and rejected.
>
> Also, PHP 4.x is bugfix branch and NO new features will be added there.
> In 5.x there is ext/mysqli, which have much more functionality than ext/mysql and you should be using it instead.
>
> --
> Wbr,
> Antony Dovgal
>