Hi, maximum precision allowed is 18 digits you have here 0.6869 5652 1739 1304 3478 2 - 21 digits if you put 0.686956521739130434 this value all will be ok but i suppose you should use VarChar field for this if you do not need calculations
Karol Bieniaszewski --- In [email protected], "angel_ignacio_colmenares" <angel_ignacio_colmenares@...> wrote: > > hello, > I'm writing a firebird provider for ServiceStack.OrmLite and unit tests > ask for store the value : 0.686956521739130434782 in a table. > the datatable is simple: > > CREATE TABLE TEST > ( > v1 float, > v2 float > ); > > but when executing this statement: > > insert into Test (v1, v2) > values( > 0.686956, > 0.686956521739130434782 > ); > > throws this error: > > SQL Message : -104 > Invalid token > > Engine Code : 335544569 > Engine Message : > Dynamic SQL Error > SQL error code = -104 > Token unknown - line 4, column 1 > 0 > > > what is wrong in this case? > must i use another data type ? >
