how collation and character set works
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.
Subject
Views
Written By
Posted
how collation and character set works
4897
April 08, 2011 04:26PM
1486
April 09, 2011 08:53AM
1859
April 10, 2011 12:07AM
1966
April 10, 2011 12:15PM
1635
April 10, 2011 01:19PM
1601
April 14, 2011 11:45AM
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.