On 7 avr, 22:16, "Michael Bayer" <mike...@zzzcomputing.com> wrote: > 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'))
Is there a solution to define this collate at the level of mapper or table definition ? I would like define this "parameter" globally to my application. 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 -~----------~----~----~----~------~----~------~--~---