[Tickets #9617] Re: db_migrate and incorrect charset handling

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9617
------------------------------------------------------------------------------
  Ticket             | 9617
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | db_migrate and incorrect charset handling
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Jan Schneider, Michael Rubinsky
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2011-04-04 16:46) wrote:

Okay, but this opens a complete new can of worms. The "SELECT ...  
WHERE tag_name IN (...)" won't work in this case, because it is case  
sensitive.
The correct solution would be to delegate the lowercasing to the  
database, but at least for SQLite this doesn't seem to work. "SELECT  
LOWER('TYÖ')" returns "tyÖ" there. It works fine in MySQL though.