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
-~----------~----~----~----~------~----~------~--~---

Reply via email to