Re: [Sqlalchemy-tickets] [sqlalchemy] #487: "case-insensitive" (and "case-sensitive"?) SQL operations

[sqlalchemy <mi...@zz...>]

#487: "case-insensitive" (and "case-sensitive"?) SQL operations
--------------------------------+------------------------------------------
      Reporter:  zzzeek         |      Owner:  zzzeek
          Type:  enhancement    |     Status:  closed
      Priority:  medium         |  Milestone:  blue sky
     Component:  sql            |   Severity:  major - 1-3 hours
    Resolution:  wontfix        |   Keywords:  case insensitive comparisons
Progress State:                 |
  completed/closed              |
--------------------------------+------------------------------------------
Changes (by zzzeek):

 * status:  assigned => closed
 * resolution:   => wontfix
 * status_field:  in queue => completed/closed


Comment:

 closing this for these reasons:

 1. the patch here is seven years old and the code is entirely unusable.

 2. "case insensitive" operations can't reliably be achieved using LOWER()
 or UPPER(), as these do not accommodate unicode case folding - see
 http://www.w3.org/International/wiki/Case_folding.

 3. the general idea of working an expression like `func.lower()` into
 string comparison operations is simple, a simple recipe has been added at
 UsageRecipes/StringComparisonFilter.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/487#comment:7>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python