SQLite Forum

create unique index and order by not really unique or ordered properly
Login
Here is the info you requested

```
sqlite> PRAGMA table_info(Answers);
0|AnswerID||0||0
1|Answer||0||0
2|lasteditdate||0||0
3|lastedituser||0||0
4|status||0||0
```

typeof...

```
sqlite> select answerid, typeof(answerid) from answers;
10070|text
10090|text
10120|text
10140|text
10160|text
10440|text
10470|text
10540|text
11500|text
11630|text
11650|text
```