----- Original Message -----
From: "Bogusław_Brandys" <[EMAIL PROTECTED]>
Hello,
Maybe someone could explain me how to properly store float/decimal values
into sqlite 3.X database ?
I created test table:
create table test(number double);
insert into test(number) values(11);
Now it looks like:
11.0
so, '.' seems to be always decimal separator.
But under my Windows XP decimal separator is ',' and I have problem
retrieving this value using delphi.
Of course I could set DecimalSeparator to '.' , but this require to use
'.' widely in program which is not feasible.
Is there any pragma to set decimal separator it for sqlite database ?
Whatever tool in Delphi you are using to display the data is probably the
culprit. The numbers are stored in the database as numbers, and not as
text. The decimal comes from whatever printf() function or parsing function
pulled the data out and printed it on the screen.
Robert
