you're free to access the raw connection and use the pysqlite create_collation method. If you'd like to assemble this on all connections, look into the PoolListener API described in http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/interfaces.html?highlight=poollistener#sqlalchemy.interfaces.PoolListener and implement the "connect" method.
KLEIN Stéphane wrote: > > Hi, > > I use sqlalchemy with sqlite backend. > > I've one table with unicodes fields. When I launch one query with > order > statement on unicode field, I've bad sort result. I've one issue with > all > no ASCII characters. > > I've see some information about sqlite collation ( > http://www.sqlite.org/capi3ref.html#sqlite3_create_collation ) and > pysqlite collation ( > http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-and- > using-collations > ). > > I found also locale.strcoll(string1, string2) ( > http://docs.python.org/library/locale.html?highlight=locale#module- > locale) to compare two unicode string. > > Now, I wonder how can I perform a unicode sort with sqlalchemy and > sqlite > backend ? > > Thanks for your help, > Stephane > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---