Jackcess / Bugs / #112 Column.getScale() of Currency field returns zero

#112 Column.getScale() of Currency field returns zero

Milestone: 2.0.7

Status: closed

Owner: James Ahlborn

Labels: None

Priority: 1

Updated: 2014-11-22

Created: 2014-11-22

Creator: Martin Jericho

Private: No

Column.getScale() of DataType.MONEY field returns zero.

It looks like Access internally uses a scale of 4 but doesn't report it. I realise it is something that users of the library can hard code instead of relying on the value of getScale() but it might be an idea for you to hard code it in the library (and also getPrecision() if you can work out what its value is) so that it is consistent with DataType.NUMERIC.

Thanks for the great library!

Discussion

James Ahlborn - 2014-11-22

status: open --> closed

assigned_to: James Ahlborn

Group: Unassigned --> 2.0.7
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

James Ahlborn - 2014-11-22

money columns should now report 4 for scale and 19 for precision. changes are in trunk and will be in the 2.0.7 release.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Martin Jericho - 2014-11-22

Thanks James.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Column.getScale() of Currency field returns zero

Group

Searches

Help

#112 Column.getScale() of Currency field returns zero

Discussion