Data type question

31/03/2006, 11h36

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 ?
Currency ?

TIA
--
Best regards
Ian Robinson

31/03/2006, 14h51

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

31/03/2006, 11h36	#1 (permalink)
Ian Robinson Messages: n/a Hébergeur:	Data type question 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 ? Currency ? TIA -- Best regards Ian Robinson

31/03/2006, 14h51	#2 (permalink)
noone Messages: n/a Hébergeur:	Re: Data type question 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

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email