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: geraldo.eb...@gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users