Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:57425
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain oracle.com from 141.146.126.227 cause and error)
To: Daniel Convissor <danielc@analysisandsolutions.com>
Cc: PHP Internals List <internals@lists.php.net>
In-Reply-To: <20111118210619.GA13490@panix.com>
References: <20111118210619.GA13490@panix.com>
Content-Type: text/plain; charset="UTF-8"
Organization: Oracle Corporation
Date: Thu, 19 Jan 2012 13:50:47 +0100
Message-ID: <1326977447.2722.10.camel@guybrush>
Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: Re: [PHP-DEV] mysqli_fetch_field() mysqlnd & libmysql differences
From: johannes.schlueter@oracle.com (Johannes =?ISO-8859-1?Q?Schl=FCter?=)

Hi,

On Fri, 2011-11-18 at 16:06 -0500, Daniel Convissor wrote:
> The "length" property is what's tripping up my unit tests.  I'm building
> PHP 5.4 from svn for both tests.  The only difference between them is
> the with-mysqli declaration.  Here is a table summarizing the situation:
>=20
> type   libmysql  mysqlnd
> ----   --------  -------
> TEXT      65535   196605
> CHAR(2)       2        6
>=20
> Is this intended behavior?

Your server seems to be configured for UTF-8 by default. In my tests the
behavior for both libraries (myslqnd & libmsql) is the same if you mind
the character set (use SET NAMES etc.)

The documentation tells

        unsigned long length
       =20
        The width of the field. This corresponds to the display length,
        in bytes.
       =20
        The server determines the length value before it generates the
        result set, so this is the minimum length required for a data
        type capable of holding the largest possible value from the
        result column, without knowing in advance the actual values that
        will be produced by the query for the result set.
       =20
        http://dev.mysql.com/doc/refman/5.5/en/c-api-data-structures.html
       =20
So it is working in bytes and has to hold all possible values.

I'll mark #60333 as bogus (expected behavior) once master works for
login ...

johannes
--=20
Johannes Schl=C3=BCter, MySQL Engineering Connectors and Client Connectivit=
y

ORACLE Deutschland B.V. & Co. KG, Riesstr. 25, D-80992 M=C3=BCnchen
Registergericht: Amtsgericht M=C3=BCnchen, HRA 95603 Gesch=C3=A4ftsf=C3=BCh=
rer: J=C3=BCrgen Kunz
Komplement=C3=A4rin: ORACLE Deutschland Verwaltung B.V.
Hertogswetering 163/167, 3543 AS Utrecht, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Gesch=C3=A4ftsf=C3=BChrer: Alexander van der Ven, Astrid Kepper, Val Maher