Horton

Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)

Benedikt Eric Heinen <beh@icemark.ch>

View thread View on postgr.es
From: Benedikt Eric Heinen <beh@icemark.ch>
To: Patrice Hédé <patrice@idf.net>
Cc: pgsql-sql@postgreSQL.org
Date: 1998-06-22T11:54:53Z
Lists: 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.