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

From: Benedikt Eric Heinen <beh(at)icemark(dot)ch>
To: Patrice Hédé <patrice(at)idf(dot)net>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)
Date: 1998-06-22 11:54:53
Message-ID: Pine.LNX.3.96.980622135105.29726B-100000@fenun.icemark.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Patrice Hédé 1998-06-22 13:11:16 Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)
Previous Message Patrice Hédé 1998-06-22 08:30:28 Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)