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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
