backwards compatibility when exporting MYSQL 5 BIT fields

2005-12-12 Thread Adam Lipscombe
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

Re: backwards compatibility when exporting MYSQL 5 BIT fields

2005-12-12 Thread Gleb Paharenko
Hello. Add --hex-blob to mysqldump command line options. Adam Lipscombe wrote: Folks I am trialling MySQL 5 before we all upgrade, however others need to = import=20 my dump files into their existing MySQL4.x databases MySQL 5 mysqldump seems exports BIT fields as true