Try this: CREATE TABLE HTS.TEST1(ID BIGINT, ZEIT DECIMAL(8,7))
INSERT INTO HTS.TEST1 (ID, ZEIT) VALUES (1,0.000008); Then the value in Zeit is 0.00001 On 15 Jan., 13:25, Christoph Läubrich <[email protected]> wrote: > I'm using exact decimal in a project with this definition: > CREATE TABLE Eintrag (ID BIGINT AUTO_INCREMENT NOT NULL, ZEIT > DECIMAL(4,2), PRIMARY KEY (ID)) > and it works fine, where ZEIT are values like: > 2.34 > or something, mabe a bug in the statement parser. Have you tried using a > prepared statment and setBigDecimal(new BigDecimal("0.00008"))? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
