Subject | best type for storing 0.686956521739130434782? |
---|---|
Author | angel_ignacio_colmenares |
Post date | 2012-02-02T18:39:24Z |
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 ?
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 ?