Why does sqlite converts . To ,

See more:

C#

SQL

Hello everyone,

I am completely confused by SQLite right now.
I use the System.Data.SQLite Version for C#

I have two Tables:

Table 1:
In it I have created two columns (more but they are the important in this case and the statement is way to long to post it). The first one is called RecStat and the second one DOXinM.
Both are a Decimal and are created like this:
...

[RectStat] Decimal,
[DOXinM] Decimal,

...

The Create Table statement looks like this:

Create Table If Not Exists "Table1"

(..Columns..);

When I insert a value in this table the decimal works perfectly fine and when I read it out it works too on the xaml GUI.

After that I created a second Table which also has a Decimal Column.
I Created the table the same way (this is a short one, So i can give the whole statement)

Create Table If Not Exists "Table2" (
 [ID] Integer Not Null Primary Key,
 [Material] VarChar(10],
 [Thickness] Decimal);

In both case I do the same insert for the Decimal Column:

Insert into Table1 ('RectStat') values ('10.5');
Insert into Table1 ('DOXinM') values ('1.3');
Insert into Table2 ('Thickness') values ('0.25');

Now the Database inserts the first two Statements as 10.5/1.3 and the last one as 0,25
When I read out the value the first two works perfectly fine but the last one is shown without the numbers after the decimal "point".

So my question is.
Why does this happens?
(Btw I have more than 20 Decimals columns in my table and the "Thickness" is the only one with this problem)

I hope you can help me.

Thanks in Advance
Richard

What I have tried:

Tried different Values (Had the hope that it was because of the 0.25)
Tried it without the ''. But than the statement thought it had three values for two columns...