Lol, I used it everytime with a "," and wondering why my select always
return an integer instead of a floating point value.
Sometimes I should read documentation more ... lol.
But the "." is mostly used as an thousand delimiter.
But thanks that I know this now. Need to rewrite many things now.
On 27 Jun 2010, at 9:51pm, Jay A. Kreibich wrote:
> Make sure your application is not locale aware.
You can handle a locale-aware application without problems. Just make sure
your library for accessing SQLite converts numbers from and to your locale
format for numbers.
Simon.
On 27 Jun 2010, at 9:51pm, Jay A. Kreibich wrote:
> On Sun, Jun 27, 2010 at 07:04:17PM +0100, Simon Slavin scratched on the wall:
>
>> But you should know that SQLite itself does not understand locales
>> at all. It wants a ',' for decimals input and produces a '.' in
This way, of course, an
On Sun, Jun 27, 2010 at 07:04:17PM +0100, Simon Slavin scratched on the wall:
> 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
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
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
6 matches
Mail list logo
