order by question

[steeve123]

create table t (name varchar2(30));
insert into t values('Zoro');
insert into t values('Équipement');
select name from t order by name;
select name from t order by name;

NAME
------------------------------
Zoro
Équipement


How can i make the name Équipement ordered before the name Zoro?

[davey23uk]

stick a desc on the end

[steeve123]

I have thousand of record this was an example.
We want caracter with accent to not be at the end of the sort.


If i would have the word "equipement" without accent, the result would be like this:


equipement
zoro
Équipement

i want the following
equipement
Équipement
zoro

[slimdave]

Use an appropriate NLS value for your character set.

http://download-west.oracle.com/docs...099.htm#i78399