Why SQLite not allow in same table on different rows if we use '0' and '0.' as a primary key

Question

Tarun Kumar · Answer

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.

interview

Why SQLite not allow in same table on different rows if we use '0' and '0.' as a primary key

Can you answer this question?

1 Answers