I'd use, for MySQL, <column name="age" size="4,1" type="DECIMAL" />
-----Original Message----- From: Phillip Rhodes [mailto:[EMAIL PROTECTED]] Sent: 27 November 2002 03:04 To: [EMAIL PROTECTED] Subject: what column type to use for 123.5? 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
