Why SQLite not allow in same table on different rows if we use '0' and '0.' as a primary key
181630-Sep-2015
interview
Home / DeveloperSection / Interviews / Why SQLite not allow in same table on different rows if we use '0' and '0.' as a primary key
Tarun Kumar
30-Sep-2015When 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.