theres a whole bunch of crap regarding case sensitivity in compares. at this point ive been asked about three thousand times for ILIKE so sure, we can add it...if we are adding a Like() construct, with a visit_like() in compiler, thats great; DB's that dont have ILIKE can pull out lower(x) LIKE(lower(y)) instead. have ilike() produce a _Like object with "case_sensitive=False".
there is also a general notion of "case sensitive compare"/"case insensitive compare". we have a rather involved way to solve this which is talked about in ticket #487, including a PG patch. the ultimate ability is to put a flag on Column "case_insensitive_compares" that would produce a DB-specific "case insensitive" comparison operation automatically. but complicating matters is MySQL where compares are *already* case insensitive unless you play around with their non-SQL COLLATE expression. something that should be looked about/thought about with regards to this matter. On Apr 4, 2007, at 2:17 PM, Andreas Kostyrka wrote: > > * Paul Johnston <[EMAIL PROTECTED]> [070404 20:11]: >> >> Hi, >> >>> Maybe I'm not understanding this. Is ILIKE only a mysql thing? >>> So is >>> LIKE normally case insensitive in complaint SQL database? >>> >>> >> ILIKE is quasi-standard. Postgres has it as well, but MSSQL doesn't - >> all LIKEs (and in equals too in fact) are case insensitive. > Wrong, the postgresql docs say it exactly the other way: > > The key word ILIKE can be used instead of LIKE to make the match > case-insensitive according to the active locale. This is not in the > SQL standard but is a PostgreSQL extension. > > http://www.postgresql.org/docs/current/static/functions- > matching.html#FUNCTIONS-LIKE > > Andreas > > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---