[mythtv-users] Custom Schedule for Formula One|Formula 1|F1GP
Robert Longbottom
rongblor at googlemail.com
Mon Mar 21 16:31:16 UTC 2011
On 21/03/2011 14:54, Michael T. Dean wrote:
> 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
I knew I should have checked that before I wrote it :-)
Robert.
More information about the mythtv-users
mailing list