From: Shawn Green
Date: June 15 2012 7:05pm
Subject: Re: Foreign key and uppercase / lowercase values
List-Archive: http://lists.mysql.com/mysql/227680
Message-Id: <4FDB8787.5020506@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 6/15/2012 1:00 PM, Rick James wrote:
> You are very close to a standalone test case.  Please create such.  Then post it on bugs.mysql.com .
>
>> -----Original Message-----
>> From: GF [mailto:ganfab@stripped]
>> Sent: Friday, June 15, 2012 12:45 AM
>> To: Rick James
>> Cc: Shawn Green; mysql@stripped
>> Subject: Re: Foreign key and uppercase / lowercase values
>>
>> I think the following might give complete information (I removed some
>> columns not involved in the problem)
>>
>> Server version: 5.1.49-3 (Debian)
>>
>> SET collation_connection = utf8_unicode_ci; Query OK, 0 rows affected
>> ...

Before he submits a test case, he should also review
http://bugs.mysql.com/bug.php?id=27877
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-21.html

This has been a well-discussed problem both inside and outside the MySQL 
development processes.

Regards,
-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN