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

[Robert Longbottom]

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.