Re: How to migrate Fields type BIT from MS SQL to MySQL

[Dmitry Tolpeko]

Hi Claudio,

MySQL supports the BIT data type. Please have a look at http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html

mysql> create table bit1 (col1 bit);
Query OK, 0 rows affected (0.20 sec)

mysql> insert into bit1 values (1);
Query OK, 1 row affected (0.05 sec)

mysql> insert into bit1 values (5);
Query OK, 1 row affected (0.03 sec)

mysql> insert into bit1 values (0);
Query OK, 1 row affected (0.05 sec)

mysql> select * from bit1;
+------+
| col1 |
+------+
| 1 |
| 5 |
| 0 |
+------+
3 rows in set (0.00 sec)


Best regards, Dmitry Tolpeko
SQLWays - Database migration tool for MySQL
http://www.ispirer.com