Re: mysqli_fetch_field() mysqlnd & libmysql differences

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