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

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 :

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

skip this character -
row this-is-a-text
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

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

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.