<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Incompatibilities</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="mysqlnd.config.html">Runtime Configuration</a></div>
<div class="next" style="text-align: right; float: right;"><a href="mysqlnd.persist.html">Persistent Connections</a></div>
<div class="up"><a href="book.mysqlnd.html">Mysqlnd</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="mysqlnd.incompatibilities" class="chapter">
<h1>Incompatibilities</h1>
<p class="para">
MySQL Native Driver is in most cases compatible with MySQL Client Library
(<em>libmysql</em>). This section documents incompatibilities
between these libraries.
</p>
<ul class="itemizedlist">
<li class="listitem">
<p class="para">
Values of <em>bit</em> data type are returned as binary strings
(e.g. "\0" or "\x1F") with <em>libmysql</em> and as decimal
strings (e.g. "0" or "31") with <em>mysqlnd</em>. If you want the
code to be compatible with both libraries then always return bit fields as
numbers from MySQL with a query like this:
<em>SELECT bit + 0 FROM table</em>.
</p>
</li>
</ul>
</div>
<hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="mysqlnd.config.html">Runtime Configuration</a></div>
<div class="next" style="text-align: right; float: right;"><a href="mysqlnd.persist.html">Persistent Connections</a></div>
<div class="up"><a href="book.mysqlnd.html">Mysqlnd</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
