verifying unicode locale support

Поиск
Список
Период
Сортировка
От Holger Klawitter
Тема verifying unicode locale support
Дата
Msg-id 200404131111.16961.lists@klawitter.de
обсуждение исходный текст
Ответы Re: verifying unicode locale support  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: verifying unicode locale support  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there,

triggered by the recent questions about sorting, I started digging into my
problems with upper('ä')='ä' when using LC_CTYPE and LANG = de_DE.UTF-8.

I have checked with Java (toUpperCase()) and C (see attached program, might
help others) that my locale is working, but postgres (initdb and postmaster
running with LANG=de_DE.utf8, -E UNICODE) still insists that upper('ä')
equals 'ä'. What else can be wrong?

Mit freundlichem Gruß / With kind regards
    Holger Klawitter
- --
lists <at> klawitter <dot> de

- ------snip------
#include <stdio.h>
#include <locale.h>
#include <wchar.h>

int main()
{
    if (!setlocale(LC_CTYPE, "")) {
        fprintf(stderr, "Can't set the specified locale! "
                        "Check LANG, LC_CTYPE, LC_ALL.\n");
        return 1;
    }
    wchar_t* text = L"ä";
    printf( "is: towupper(%x) = %x\n", text[0], towupper(text[0]) );
    return 0;
}
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAe6601Xdt0HKSwgYRAvtlAJ9nfZHVHLcDeCCok/ylgr1jtZrXBQCff29h
bKiclwE2ahspLQZSBKJWIuo=
=1IaE
-----END PGP SIGNATURE-----


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

Предыдущее
От: "Development - multi.art.studio"
Дата:
Сообщение: performance problem aftrer update from 7.1 to 7.4.2
Следующее
От: Holger Klawitter
Дата:
Сообщение: Re: Filesystem vs. Postgres for images