[sqlalchemy] Re: SQL Server weird sorting behaviour

2011-07-14 Thread Eric Ongerth
Sounds like you might want to set a different collation? I don't know if sql server lets you do that per column, per table, or just per database. http://msdn.microsoft.com/en-us/library/ms144250.aspx --- some collation examples On Jul 14, 4:51 am, Massi massi_...@msn.com wrote: Hi everyone,

Re: [sqlalchemy] Re: SQL Server weird sorting behaviour

2011-07-14 Thread Michael Bayer
or CAST the column as int more likely http://msdn.microsoft.com/en-us/library/aa226054%28v=sql.80%29.aspx SQLA's construct: http://www.sqlalchemy.org/docs/core/expression_api.html?highlight=cast#sqlalchemy.sql.expression.cast On Jul 14, 2011, at 7:19 PM, Eric Ongerth wrote: Sounds like you