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

Поиск
Список
Период
Сортировка
От Benedikt Eric Heinen
Тема Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)
Дата
Msg-id Pine.LNX.3.96.980622135105.29726B-100000@fenun.icemark.ch
обсуждение исходный текст
Ответ на Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)  (Patrice Hédé <patrice@idf.net>)
Ответы Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)
Список 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.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Patrice Hédé
Дата:
Сообщение: Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)
Следующее
От: Patrice Hédé
Дата:
Сообщение: Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)