Further investigation shows that this is not Informix or the informix driver either this behaviour is definitely without doubt JDBC. This is the same for mySQL db.
Originally posted by Sivaraman Lakshmanan:
Did you tried using java.math.BigDecimal class?
Pitty it doesn't keep the existing format in the db.
I hope formating a large number of values from the database is performant.