At 16.40 15/06/2012 -0400, Shawn Green wrote:
>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.
ß = Eszett (which in German is the spelling of SZ, although it originated as a
double S ligature (U+017F + s) - SZ comes from its "sharp" pronunciation).
The absence of an uppercase equivalent and its ligature behavior more evident than for
other ligatures (although this has changed with the 1996 reform of German writing) have
caused more than a headache to people dealing with charsets and collations.
Speaking of collations, I found this website useful (especially when I had to compare
collations of different RDBMSs):
Sorry for being OT, but every now and then it's worthwhile to share also some OT
>MySQL Principal Technical Support Engineer
>Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
>Office: Blountville, TN
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql