When primary key is numeric type then the problem is occurs,
if we use TEXT as a datatype with primary key then it will execute
successfully. All the rows having unique primary key. For a column with a
numeric type, SQLite thinks that '0' and '0.0' are the same values because they
compare it equal to one another numerically. so the value will not be unique.
Total Post:107
Points:535When primary key is numeric type then the problem is occurs, if we use TEXT as a datatype with primary key then it will execute successfully. All the rows having unique primary key. For a column with a numeric type, SQLite thinks that '0' and '0.0' are the same values because they compare it equal to one another numerically. so the value will not be unique.