Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:57426 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 53089 invoked from network); 19 Jan 2012 13:09:22 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 19 Jan 2012 13:09:22 -0000 Authentication-Results: pb1.pair.com header.from=ulf.wendel@oracle.com; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=ulf.wendel@oracle.com; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain oracle.com from 141.146.126.227 cause and error) X-PHP-List-Original-Sender: ulf.wendel@oracle.com X-Host-Fingerprint: 141.146.126.227 acsinet15.oracle.com Received: from [141.146.126.227] ([141.146.126.227:25537] helo=acsinet15.oracle.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 10/E1-37696-106181F4 for ; Thu, 19 Jan 2012 08:09:22 -0500 Received: from ucsinet21.oracle.com (ucsinet21.oracle.com [156.151.31.93]) by acsinet15.oracle.com (Switch-3.4.4/Switch-3.4.4) with ESMTP id q0JD9HX2001960 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 19 Jan 2012 13:09:18 GMT Received: from acsmt357.oracle.com (acsmt357.oracle.com [141.146.40.157]) by ucsinet21.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id q0JD9Gd1028315 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 19 Jan 2012 13:09:16 GMT Received: from abhmt113.oracle.com (abhmt113.oracle.com [141.146.116.65]) by acsmt357.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id q0JD9FOQ027051; Thu, 19 Jan 2012 07:09:15 -0600 Received: from [192.168.2.116] (/91.6.153.16) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Thu, 19 Jan 2012 05:09:15 -0800 Message-ID: <4F1815F8.9010702@oracle.com> Date: Thu, 19 Jan 2012 14:09:12 +0100 User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: =?UTF-8?B?Sm9oYW5uZXMgU2NobMO8dGVy?= CC: Daniel Convissor , PHP Internals List References: <20111118210619.GA13490@panix.com> <1326977447.2722.10.camel@guybrush> In-Reply-To: <1326977447.2722.10.camel@guybrush> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Source-IP: ucsinet21.oracle.com [156.151.31.93] X-CT-RefId: str=0001.0A090206.4F1815FE.00DB,ss=1,re=0.000,fgs=0 Subject: Re: [PHP-DEV] mysqli_fetch_field() mysqlnd & libmysql differences From: ulf.wendel@oracle.com (Ulf Wendel) Am 19.01.2012 13:50, schrieb Johannes Schlüter: > 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: >> >> type libmysql mysqlnd >> ---- -------- ------- >> TEXT 65535 196605 >> CHAR(2) 2 6 >> >> 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.) ACK, likely a bogus report. "MySQLnd always assumes the server default charset. This charset is sent during connection hand-shake/authentication, which mysqlnd will use. Libmysql uses the default charset set in the my.cnf or by an explicit call to mysqli_options() prior to calling mysqli_real_connect(), but after mysqli_init().", http://www.php.net/manual/en/mysqli.construct.php Ulf