[ADMIN] Re: case senesitive

[Peter Eisentraut]

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
[EMAIL PROTECTED]                   75262 Uppsala
http://yi.org/peter-e/            Sweden