oracle underscore sort problem
Posted on 2001-09-11
I have a problem when I execute an SQL query on oracle:
select uid, title from table_name order by title
The title field is of type string but the sorting ignores the underscore character'_' when is sorting records. Ex:
I want that underscore to be considered when sorting. How can I sove this problem?