Why Doesn't Sqlite Allow Me To Use '0' And '0.0' As The Primary Key O

1.	Why Doesn't Sqlite Allow Me To Use '0' And '0.0' As The Primary Key On Two Different Rows Of The Same Table?
Answer» This PROBLEM occurs when your primary KEY is a numeric TYPE. Change the datatype of your primary key to TEXT and it should work. Every row must have a unique primary key. For a column with a numeric type, SQLite thinks that '0' and '0.0' are the same value because they compare equal to ONE another numerically. HENCE the values are not unique.

Why Doesn't Sqlite Allow Me To Use '0' And '0.0' As The Primary Key On Two Different Rows Of The Same Table?

Answer»

This PROBLEM occurs when your primary KEY is a numeric TYPE.
Change the datatype of your primary key to TEXT and it should work.
Every row must have a unique primary key.
For a column with a numeric type, SQLite thinks that '0' and '0.0' are the same value because they compare equal to ONE another numerically.
HENCE the values are not unique.