Migrating database from VFP to MySQL

[StewartUK]

I'm looking into migrating my database from VFP to MySQL.

Most of the data type mappings seem straightforward, but I'm not sure how to deal with the VFP logical data type - that is TRUE and FALSE.

It seems that I can either use tinyint(1) or bit(1) for creating the field.

What would you recommend and why?

Thanks,

Stewart

 

[ingresman]

The refereence suggests tinyint. See

http://dev.mysql.com/doc/refman/4.1/en/other-vendor-data-types.html

For details. It doesn't give a reason but as it's what they suggest.....

 

[DonQuichote]

I would suggest you use the BOOL data type. Note that is will be converted to TINYINT(1) internally for now, but future versions of MySQL may have a real boolean data type. Also, the BOOL data type means exactly what you mean, whereas TINYINT is not really descriptive. Unless you have a really old MySQL server, you can use the keywords TRUE and FALSE, so you will hardly notice that you are not dealing with real booleans.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)