From: Martijn Tonies
Date: January 11 2006 12:01pm
Subject: BIT datatype and prepared statements
List-Archive: http://lists.mysql.com/mysql/193756
Message-Id: <020301c616a6$bf382db0$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi there,

Still tracking down the BIT problems. For a simple statement, prefixing it
with
b'<binary value>' works (as written in the documentation). Even with the
STRICT
mode turned ON.

However, for prepared statements, how do you bind a BIT(1) or BIT(n)?

This doesn't list BIT at all:
http://dev.mysql.com/doc/refman/5.0/en/c-api-prepared-statement-datatypes.html


Any pointers?


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com