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