how collation and character set works
Posted by: Hossein amin
Date: April 08, 2011 04:26PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
how collation and character set works
4683
April 08, 2011 04:26PM


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.