I made my own character set compiled its 8-bit i want to add ability to ignore accent of a character in sorting with my own collation.
unicode has ability to do that here phonebook table exmple in mysql doc
here is url :
MySQL :: MySQL 5.5 Reference Manual :: 9.4.4 Adding a UCA Collation to a Unicode Character Set
simply i want to skip some characters in sorting and comparing like this
skip this character -
row 1-1-2-342
sort like 112342
where is the ability in MY_COLLATION_HANDLER structure?