how collation and character set works

[Hossein amin]

Hello
I made a simple character set 8-bit i want to add ability to ignore some characters on collating like phone book example in doc
here is url :
http://dev.mysql.com/doc/refman/5.5/en/adding-collation-unicode-uca.html

simply i want to skip some characters in sorting and comparing like this

skip this character -
row this-is-a-text
query
select col from tbl where col=thisisatext;
result will be row

what i must do to get this effect?

note that i want my character set to be 8-bit



Edited 1 time(s). Last edit at 04/08/2011 04:26PM by Hossein amin.