MySQL ignoring BigDecimal precision.

[C N Davies]

I'm using MySQL and I find that when Open JPA generates the tables it
defaults any BigDecimal columns to Decimal(10,0) ignoring my annotation that
says I want 10,6.  I'm using:

 

                @Column(name="chargerate", precision=10,scale=6,
nullable=false)

 

The manual says there is an issue with Floats and Doubles but doesn't
mention BigDecimals:

 

"Floats and doubles may lose precision when stored in some datastores."

 

I'm using InnoDB tables on MySQL 5.1.32

 

Thanks 

 

Chris