[mythtv] Ticket #8215: MythWeb hostname/setting hostname comparison is not case-insensitive

[Raymond Wagner]

On 6/11/2010 07:52, ryan patterson wrote:
>>   We control this via the database:
>>   {{{
>>   mysql>  SELECT DISTINCT hostname FROM settings\G
>>   *************************** 1. row ***************************
>>   hostname: jessica
>>
>>   mysql>  SELECT COUNT(0) FROM settings WHERE hostname = 'JESSICA'\G
>>   *************************** 1. row ***************************
>>   COUNT(0): 340
>>
>>   mysql>  SELECT COUNT(0) FROM settings WHERE hostname = 'JeSsIcA'\G
>>   *************************** 1. row ***************************
>>   COUNT(0): 340
>>   }}}
>>
>>   So in short, fix the database and all should be wel.
>>      
> I don't mean to be a pain, but I don't understand why this has (again)
> been marked invalid.
>    

When you access a MySQL database through PHP, all you are doing is 
sending those query strings through to the server. He's showing you that 
on his system, those same queries are case insensitive. I just tested 
and they are on mine as well. If yours are not, then your database is 
not configured in the manner that MythTV expects. This is configuration 
error, and not a bug.