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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
