Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:57892
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain analysisandsolutions.com from 166.84.1.78 cause and error)
Date: Fri, 17 Feb 2012 08:38:11 -0500
To: Johannes =?utf-8?B?U2NobMO8dGVy?= <johannes.schlueter@oracle.com>
Cc: PHP Internals List <internals@lists.php.net>,
	Ulf Wendel <ulf.wendel@oracle.com>
Message-ID: <20120217133811.GA17442@panix.com>
References: <20111118210619.GA13490@panix.com>
 <1326977447.2722.10.camel@guybrush>
 <20120121133107.GA7255@panix.com>
 <1327311604.5972.51.camel@guybrush>
 <20120124025600.GA337@panix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <20120124025600.GA337@panix.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
Subject: Re: [PHP-DEV] mysqli_fetch_field() mysqlnd & libmysql differences
From: danielc@analysisandsolutions.com (Daniel Convissor)

Hi Johannes and Ulf:

On Mon, Jan 23, 2012 at 09:56:00PM -0500, Daniel Convissor wrote:
> Hi Johannes:
> 
> > We have to live with the information the server gives us. The server
> > gives us the information in bytes. And frankly in PHP a string has no
> > encoding information, so in many cases that is a good answer. But
> > nonetheless the documentation should be improved/fixed.
> 
> Further experimenting reveals that libmysql has the same behavior of
> multiplying the length of string fields by 3 when the character set is
> set to "utf8".
> 
> A related problem was found by the test script.  libmysql is completely
> ignoring the character set information in my.cnf.  Plus, if one forces a
> character set by calling options(SET NAMES utf8) before connecting,
> character_set_name() still returns unexpected information.
> 
> Can you please take a look at this test script:
> http://www.analysisandsolutions.com/php/libmysql.ignoring.character.set.php

Can one of you please examine why libmysql is not acting as documented
and reply here in the near future?

Thanks,

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409