http://www.perlmonks.org?node_id=504559


in reply to Re^2: Handle MySQL BIT data type in Perl
in thread Handle MySQL BIT data type in Perl

MySQL v4.1 and below had stub-like support for BIT, which is why the current version of DBD::mysql sorta supports it. From the MySQL 4.1 Reference Manual:

In versions of MySQL up to and including 4.1, BIT is a synonym for TINYINT(1).

Whereas in version 5:

This data type was added in MySQL 5.0.3 for MyISAM, and extended in 5.0.5 to MEMORY, InnoDB, and BDB. Before 5.0.3, BIT is a synonym for TINYINT(1)

  • Comment on Re^3: Handle MySQL BIT data type in Perl