CODEWITHSUNDEEP
sqlitecollation
user1065969
user1065969

Reputation: 599

SQLite3 Database - No such collation sequence error

I am getting no such collation sequence: en_US error when I try to do a select count(*) from OR insert a record into a particular table in the database.

I am no database expert but I tried to google the error and what I understand is that the table is created with COLLATION SEQUENCE function set to en_US which the SQLite is not familiar with.

Is there any solution to this error (without dropping the table and creating a new one).

Upvotes: 7

Views: 17113

Answers (1)

user1065969
user1065969

Reputation: 599

Thank you CatCall. I tried a .schema tablename and I saw that the collation sequence was set on 2 of the indexes. I dropped them and recreated without the collation sequence and the issue was fixed.

Upvotes: 1

Related Questions