On 27 Jun 2010, at 6:38pm, Gerald Ebner wrote: > 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
Now do select X/10 from MY_POINTS It's the simplest way to see whether your system is using commas for input and/or commas for output. But you should know that SQLite itself does not understand locales at all. It wants a ',' for decimals input and produces a '.' in output. If you have some aspect of your system which is handling ',', it's not part of SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
