Special characters
Posted by:
stemue
Date: March 04, 2005 05:38PM
Hi,
I would like to retrieve some rows from a table which should be sorted by their name. The name may contain special characters. The problem is that MySQL returns names beginning with special characters like á or ä after all rows beginning with a, so 'äa' will be after 'az'. Is there a simple way to treat those characters like a normal 'a' for sorting (same applies to special characters like ó, ú etc.) without using a lot of REPLACEs or an extra column containing 'clean' names?
Subject
Written By
Posted
Special characters
March 04, 2005 05:38PM
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.