On Feb 19, 2007, at 4:52 AM, Troy wrote: > It's not just the literal text or the bind param. It is how the > server compares character based data. In MySQL, MS-SQL, Sybase -- > case does not matter. In Postgres, Oracle and DB2 it does. DB2 and > Oracle (since version 10 I think) have some server-side settings to > help, but Postgres does not. >
OK totally different issue. MySQL does have a case-sensitivity setting using COLLATE. not sure what MS-SQL has and we dont yet have sybase support. we've had people report the whole lower() issue in the past and im not sure that should be "automatic" within SA. You can just explicitly say lower() across the board for case-insensitive comparisons. if SA implemented some operator for this (which could be doable, such as table.c.compare_insensitive(foo)), it would still have to use lower() for every dialect since in particular for MySQL we have no idea what the COLLATE rules are on the given table. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
