From: Shawn Green Date: June 15 2012 8:40pm Subject: Re: Foreign key and uppercase / lowercase values List-Archive: http://lists.mysql.com/mysql/227683 Message-Id: <4FDB9DC0.6020906@oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit On 6/15/2012 3:19 PM, Rick James wrote: > Those refer _only_ to German 'ß' LATIN SMALL LETTER SHARP S. The example GF gave did not involve that character. > > To my knowledge, that is the only case where MySQL changed a collation after releasing it. > Yes, it has been the only occurrence. However, the esset (sharp S) is just one example of the alternative spelling letters that were affected by the collation change. Thorn, the AE ligand, and many others fall into that same category. Regards, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN