Re: L STROKE UTF8 - collation
Posted by: Peter Gulutzan
Date: September 17, 2006 05:54PM

You mention that the collation is unicode_utf8_ci.
You are changing ctype-utf8.c.
The unicode_utf8_ci collation is affected by
ctype-uca.c. Tip: instead of weight = 0F36
you want weight = 0F32.

Background information for anyone listening in:
MySQL follows version 4.0.0 of the Unicode Collation Algorithm (ftp://www.unicode.org/Public/UCA/4.0.0/allkeys-4.0.0.txt)
when it handles utf8_unicode_ci and ucs2_unicode_ci
string comparisons. However, in later versions of UCA,
L WITH STROKE = L. So someday this change might be in
the official version. Not for a long time, though --
changing the collation affects existing indexes.

Options: ReplyQuote


Subject
Views
Written By
Posted
3522
vin
September 13, 2006 04:15AM
Re: L STROKE UTF8 - collation
1713
September 17, 2006 05:54PM
1615
September 18, 2006 08:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.