Re: searches on utf8_unicode_ci only work for ASCII
Well, rethinking about the whole issue, case folding and accent stripping sounds fine. Except that ñ, a Spanish character, is not an accented n for Spaniards (while ó is indeed an accented o) for a whole different letter with its own name.
Any way to explicitly exclude ñ from accent-stripping (but not case folding)? ç would be a similar character for Catalan, where it is definitely not the same as a c. I cannot point you to any standard. This post was originally posted at "Newbies"…
If it is somewhat complex, now that I understand the issue, I can live with it.
Subject
Views
Written By
Posted
3833
July 06, 2010 05:25AM
1867
July 07, 2010 09:29AM
Re: searches on utf8_unicode_ci only work for ASCII
1911
July 13, 2010 02:51AM
2337
July 13, 2010 08:57AM
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.