OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
backwards compatibility when exporting M<YSQL 5 BIT fields

From: Adam Lipscombe (adam.lipscombequcs.co.uk)
Date: Mon Dec 12 2005 - 07:14:36 CST

Folks

I am trialling MySQL 5 before we all upgrade, however others need to import
my dump files into their existing MySQL4.x databases

MySQL 5 mysqldump seems exports BIT fields as true = '', false = '\0'.

When that dump file is imported into MySQL 4 these value are not
interpreted correctly. MySQL4.x does not have a real BIT type , rather it
uses TINYINT(1).
Both '' and '\0' seem to be interpreted as "false", and the relevant
TINYINT(1) field is set to 0.

So far that has meant that I have to hand-edit my dump file to convert ''
to 1, '\0' to 0.

Does anyone know a way around this?

TIA - Adam Lipscombe

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql