Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:39736
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain macvicar.net from 193.227.246.108 cause and error)
Message-ID: <489B0877.6060006@macvicar.net>
Date: Thu, 07 Aug 2008 15:36:39 +0100
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: Hannes Magnusson <hannes.magnusson@gmail.com>
CC: Ulf Wendel <ulf.wendel@phpdoc.de>, Stanislav Malyshev <stas@zend.com>, 
 PHP Internals <internals@lists.php.net>
References: <4899D1F2.2060101@zend.com> <4899F71D.8010306@phpdoc.de>	 <489B03FB.9070308@phpdoc.de> <7f3ed2c30808070729w67f2bcd6nd8380724faae8180@mail.gmail.com>
In-Reply-To: <7f3ed2c30808070729w67f2bcd6nd8380724faae8180@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam_Report: Spam detection software, running on the system "lovelace.midden.org.uk", has
	identified this incoming email as possible spam.  The original message
	has been attached to this so you can view it (if it isn't spam) or label
	similar future email.  If you have any questions, see
	the administrator of that system for details.
	Content preview:  Hannes Magnusson wrote: > On Thu, Aug 7, 2008 at 16:17, Ulf
	Wendel <ulf.wendel@phpdoc.de> wrote: >> He explained to me that using SET
	NAMES is what is not recommended when >> using libmysql because: >> >> -
	there is no verification if the client knows the charset >> - the internal
	mysql->charset field will not be set properly > > Is this something we should
	add to the mysql[i]_set_charset() docs? > I've seen *bunch* of people doing
	mysql[i]_query("SET NAMES UTF8");... > > -Hannes > [...] 
	Content analysis details:   (-4.3 points, 5.0 required)
	pts rule name              description
	---- ---------------------- --------------------------------------------------
	-1.8 ALL_TRUSTED            Passed through trusted hosts only via SMTP
	-2.6 BAYES_00               BODY: Bayesian spam probability is 0 to 1%
	[score: 0.0000]
	0.1 AWL                    AWL: From: address is in the auto white-list
Subject: Re: [PHP-DEV] mysql_set_charset
From: scott@macvicar.net (Scott MacVicar)

Hannes Magnusson wrote:
> On Thu, Aug 7, 2008 at 16:17, Ulf Wendel <ulf.wendel@phpdoc.de> wrote:
>> He explained to me that using SET NAMES is what is not recommended when
>> using libmysql because:
>>
>>  - there is no verification if the client knows the charset
>>  - the internal mysql->charset field will not be set properly
> 
> Is this something we should add to the mysql[i]_set_charset() docs?
> I've seen *bunch* of people doing mysql[i]_query("SET NAMES UTF8");...
> 
> -Hannes
> 

The people doing it usually have to support PHP versions lower than 
5.2.3, we use SET NAMES on older versions of PHP.

Scott