Problem wyth Case-sensitive ORDER BY

Поиск
Список
Период
Сортировка
Искать

Problem wyth Case-sensitive ORDER BY

От:
"Erik Ferencz" <ErikFerencz@seznam.cz>
Дата:
Hi!
It is possible to make ORDER BY not CASE-SENSITIVE ??
 
I need output like this
 
Cardio
cerdio
Cordio
curdio
 
But I always get output like this
 
Cardio
Cordio
cerdio
curdio
 
 
How can I force ORDER BY to ord strings in my way?? I mean, I use charakters like ú.ľ,š,č,ť,ž that have spetial order in my language.
 
Thanks for any help

Re: Problem wyth Case-sensitive ORDER BY

От:
Richard Broersma Jr <rabroersma@yahoo.com>
Дата:
> It is possible to make ORDER BY not CASE-SENSITIVE ??
> But I always get output like this
> Cardio
> Cordio
> cerdio
> curdio
> How can I force ORDER BY to ord strings in my way?? I mean, I use charakters like ?,謻,?
> that have spetial order in my language.
> Thanks for any help


may be something like:

select name from foobar order by lower(name);

Regards,

Richard Broersma Jr.
FAQ