KLEIN Stéphane wrote: > > On 7 avr, 16:31, "Michael Bayer" <mike...@zzzcomputing.com> wrote: >> 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 >> inhttp://www.sqlalchemy.org/docs/05/reference/sqlalchemy/interfaces.htm... >> and implement the "connect" method. > > Ok, I've appended my collation function with dbapi_con.create_collation > ("my_collate", my_collate) but I don't know how can I use my collation > in query statement.
we have an expression operator collate: from sqlalchemy import collate query.order_by(collate(mycolumn, 'somecollation')) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---