[thelist] re: mysql - table formats?

Tom Dell'Aringa pixelmech at yahoo.com
Thu Nov 14 14:21:00 CST 2002


--- Tom said:
> > What type of data should I specify for a money (price) field?
> > I do want to add the values later.

--- Tony Crockford <tonyc at boldfish.co.uk> wrote:
> This would help:
>
> http://www.mysql.com/doc/en/Column_types.html
>
> I'd be inclined to go with decimal, simply because you can force
> that
> two two places.
>
> Disclaimer:
> I am not an expert.. ;o)

I chose decimal (based on that very page.) Now I want a true/false
field but I cannot find boolean in the documentation for column
types! Is it under a different name? I can't believe there isn't a
boolean type..

Tom

=====
var me = tom.pixelmech.webDeveloper();

http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com



More information about the thelist mailing list