[mythtv-users] Custom Schedule for Formula One|Formula 1|F1GP

Michael T. Dean mtdean at thirdcontact.com
Mon Mar 21 14:54:20 UTC 2011


On 03/21/2011 09:26 AM, Wayne Thomas wrote:
>>> Also mysql is case sensitive (I think)
>> I thought 'like' wasn't case sensitive and
>> http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html seems to
>> support this, saying 'In MySQL, SQL patterns are case-insensitive by
>> default.' and giving the example:
> The lower case search term '%formula 1%'  has always picked up the titles
> for me which invariably begin with an upper case 'F'.

MythTV uses case-insensitive collation for nearly all string data, 
including all program listings data, so no need to worry about 
capitalization.

Mike


More information about the mythtv-users mailing list