SQLite Forum

create unique index and order by not really unique or ordered properly
Login
What does this query show:

> ~~~
SELECT quote(answerid) FROM answers;
~~~

My guess:  One or more of those entries that look like numbers are really
strings.