Re: case senesitive

HENAFF Mari-mai FTRD/DMI/LAN writes:

> And is it possible to make a query containing an ORDER BY that is not case
> sensitive ?

Option 1:

SELECT * FROM table ORDER BY upper(field);

Option 2:

Build with --enable-locale. Most locales sort a, A, b, B, etc.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden