Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents) - Mailing list pgsql-sql

> patrice=> select accents( 'zurich' );
> accents
> ------------------------------
> z[uúÚùÙûÛüÜ]r[iíÍìÌîÎïÏ][cçÇ]h

This brings up another interesting question -- will
"upper(accentuated-string)" upcase the string properly (including upcasing
accentuated characters)? e.g. will upper("zürich") become "ZüRICH" or
"ZÜRICH"?



I'll have a look at the accents source later today...


   Benedikt

Windows 95: n.
    32-bit extensions and a graphical shell for a 16-bit patch to an 8-bit
    operating system originally coded for a 4-bit microprocessor,  written
         by a 2-bit company that can't stand for 1 bit of competition.