[sqlalchemy] Using collation sequence in SqlAlchemy against Sqlite DB

2011-10-18 Thread Roja Sen
Could someone help me to set different collation in sqlAlchemy against Sqlite DB? I tried to execute something like SELECT icu_load_collation('pl_PL', 'POLISH') when getting a connection but couldn't reference the collation sequence when creating the table object, I keep getting the following

Re: [sqlalchemy] Using collation sequence in SqlAlchemy against Sqlite DB

2011-10-18 Thread Michael Bayer
I don't know what icu_load_collation is, but SQLite's documentation points to section 6.2, Collation Sequence Examples at http://www.sqlite.org/datatype3.html which describes how to create tables with certain collations. There is also the COLLATE operator: