what column type to use for 123.5?

[Phillip Rhodes]

Trying to make the right choice here.
I have a number that will have up to one decimal place and up to whole 3 digits.
I am using a double for this number in java, but the
<column name="age" type="DOUBLE" /> is choking, although I see a double as a valid type in the dtd.

I am using tdk 2.1, mysql.

Can someone tell me what would be the appropriate column type?
Thanks!



--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>