I have had no trouble using it just as you do. Maybe you haven't set the scale yet.
This is an excerpt of my schema.xml file: <column name="moncotiza" required="true" scale="2" size="7" type="DECIMAL" /> What I usually do is to define the schema.xml file and from it obtain the .sql file via ant to create the database. Good luck, Álvaro. Jon August <[EMAIL PROTECTED]> wrote: Hey, I'm using decimal (in the schema) to store a dollar amount in my MySQL database. I get the value from a web page and convert it to a BigDecimal before storing it. For some reason, the decimal portion gets truncated and $10.32 gets stored as 10. Should I be using something other than BigDecimal or is there something else wrong? Sorry if this is not a torque question. -Jon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------- Want to start your own business? Learn how on Yahoo! Small Business.