Dear all,
1. given a table with float fields:
CREATE TABLE MY_POINTS (
Y FLOAT,
X FLOAT
);
2. and working with the German locale
3. normal queries with float fields:
select X from MY_POINTS;
-> 6,265
note: decimal separator is a comma
4. queries with calculated float fields deliver values with the wrong dec.sep.
e.g.: abs(), max(), min()
select abs(X) from MY_POINTS;
-> 6.265
note: decimal separator is a point!
select X+Y from MY_POINTS;
-> 12.65
note: decimal separator is a point!
how can this inconsistency be avoided???
un saludo
Gerald
--
_______________________________________
Gerald Ebner
Lieu dit Les Sauzines
31460 Auriac sur Vendinelle
tel. 05 34 66 97 75 / 06 35 94 53 50
email: [email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
