Case insensitive string columns in SQLAlchemy?

Question

can i create a case insensitive string column in sqlalchemy? im using sqlite, and theres probaby a way to do it through DB by changing collation, but i want to keep it in sqlalchemy/python.

Answer 1

SQLite does allow NOCASE collation on text fields:

SQLite version 3.6.22
sqlite> create table me (name text collate nocase);
sqlite> .schema
CREATE TABLE me (name text collate nocase);
sqlite> insert into me values("Bob");
sqlite> insert into me values("alice");
sqlite> select * from me order by name;
alice
Bob

and SQLalchemy has a collation() operator on a schema, but I'm not sure when you apply it.