Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc. If the script requires a 
database to demonstrate the issue, please make sure it creates 
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.

Follows is example code highlighting the bug.
Code requires MySQl database 'TestDb' created, together with a user 'tester' and password 'password' with create and insert rights to the database.

Expected result is a table TestDb.TestTbl with the following contents:
True
False
False
True

Actual result is a table TestDb.TestTbl with the following contents:
False
True



<?php
$dbh = new PDO( 'mysql:host=localhost; dbname=TestDb', 'tester', 'password');

// Create table
$query = 'create table TestDb.TestTbl (MyBoolean boolean)';
$createStatement = $dbh->prepare( $query);
$createStatement->execute();

// Attempt to insert boolean records into table - this does not work
$query = 'insert into TestDb.TestTbl set MyBoolean=?';
$statement = $dbh->prepare( $query);
$statement->bindValue( 1, true, PDO::PARAM_BOOL);
$statement->execute();
$statement->bindValue( 1, false, PDO::PARAM_BOOL);
$statement->execute();

// However by replacing booleans with integers does work
$statement->bindValue( 1, 0, PDO::PARAM_BOOL);
$statement->execute();
$statement->bindValue( 1, 1, PDO::PARAM_BOOL);
$statement->execute();

?>

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip

I've tried this on latest CVS and MySQL 5.0.22 and it works 
exactly as intended. Boolean of 1/0 (true/false) are being 
inserted.

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

This bug still exists in PHP 7.0 with MySQL.  It really ought to be fixed.  For me it only bites when PDO::ATTR_EMULATE_PREPARES is false.  Here's a complete test case:


<?php
$db = new PDO(  "mysql:host=localhost;dbname=DBNAME", "DBUSER", "DBPASS",
				array(  PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
						PDO::ATTR_EMULATE_PREPARES   => false) );
						
$db->exec( "DROP TABLE IF EXISTS TestPDO;" );
$db->exec( "CREATE TABLE TestPDO (ColT BOOLEAN, ColF BOOLEAN) ENGINE = InnoDB" );

$stmt = $db->prepare( "INSERT INTO TestPDO (ColT, ColF) VALUES (:ColT, :ColF)" );
$stmt->bindValue( ":ColT", TRUE,  PDO::PARAM_BOOL );
$stmt->bindValue( ":ColF", FALSE, PDO::PARAM_BOOL );
if (!$stmt->execute())
	echo("Bug!  Execute returned false! errorCode() was: " . $stmt->errorCode() . "\n");
	
$rowCount = $db->query("SELECT COUNT(*) FROM TestPDO")->fetch(PDO::FETCH_NUM)[0];
echo("rowCount $rowCount (expected 1)\n");
?>