Ian Robinson wrote:

> Hi,

> I'm converting a desktop application Delphi/Paradox to a web server
> application PHP/MySQL

> What data type should I use in MySQL for the following paradox datatypes ?

> Boolean ?

see the docs...
http://dev.mysql.com/doc/refman/5.0/...ata-types.html

I would use an tinyint (use a check constraint that only allows 0,1)

> Currency ?

not sure... what is the definition of the Currency data type? Number?
Char?

possibly a decimal? example: salary DECIMAL(9,2) (for mega-sports stars?)

> TIA