X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 73F143A2B41 for ; Wed, 10 Nov 2004 08:59:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60161-07 for ; Wed, 10 Nov 2004 08:59:42 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id E7C3A3A1D8F for ; Wed, 10 Nov 2004 08:59:42 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 6DA02E8A2 for ; Wed, 10 Nov 2004 11:01:41 +0200 (EET) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29859-06 for ; Wed, 10 Nov 2004 11:01:40 +0200 (EET) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id A23D2E82A for ; Wed, 10 Nov 2004 11:01:39 +0200 (EET) Message-ID: <013601c4c703$9ef98b00$0b00a8c0@forge> From: "Andrei Bintintan" To: Subject: How to support German, French and other characters. Date: Wed, 10 Nov 2004 10:59:41 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0133_01C4C714.6110C9A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200411/85 X-Sequence-Number: 15470 This is a multi-part message in MIME format. ------=_NextPart_000_0133_01C4C714.6110C9A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi to all,=20 We are using pgsql as a "multilanguage" database. But I noticed = yesterday a strange problem with the german umlaut characters. I cannot = convert the in upper case in lowercase. Probably there are also other = bad functionalities.=20 Now. I searched the internet for answers but they were not quite exact, = so I could't find a solution.=20 We use ASCII encoding for the database, but I tried the Latin1 -> Latin = 10 and the behavior is the same. In some forums there is written = something about some "locale" setting... etc etc.=20 What settings do I have to make so that we won't have these problems in = the future. We intend to work with French characters also, and in the = future with Hungarian.=20 As system the pgsql is v.7.4 running on a Suse 9.1 machine. The locale = command gives me: linz:/var/lib/pgsql/data # locale LANG=3D LC_CTYPE=3Den_US.UTF-8 LC_NUMERIC=3D"POSIX" LC_TIME=3D"POSIX" LC_COLLATE=3D"POSIX" LC_MONETARY=3D"POSIX" LC_MESSAGES=3D"POSIX" LC_PAPER=3D"POSIX" LC_NAME=3D"POSIX" LC_ADDRESS=3D"POSIX" LC_TELEPHONE=3D"POSIX" LC_MEASUREMENT=3D"POSIX" LC_IDENTIFICATION=3D"POSIX" LC_ALL=3D Thank you in advance. Andy. ------=_NextPart_000_0133_01C4C714.6110C9A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
Hi to all,
 
We are using pgsql as a "multilanguage" = database.=20 But I noticed yesterday a strange problem with the german umlaut = characters. I=20 cannot convert the in upper case in lowercase. Probably there are also = other bad=20 functionalities.
 
Now. I searched the internet for = answers but they=20 were not quite exact, so I could't find a solution.
 
We use ASCII encoding for the database, = but I tried=20 the Latin1 -> Latin 10 and the behavior is the same. In some forums = there is=20 written something about some "locale" setting... etc etc.
 
What settings do I have to make so that = we won't=20 have these problems in the future. We intend to work with French = characters=20 also, and in the future with Hungarian.
 
As system the pgsql is v.7.4 running on = a Suse 9.1=20 machine. The locale command gives me:
 
linz:/var/lib/pgsql/data #=20 locale
LANG=3D
LC_CTYPE=3Den_US.UTF-8
LC_NUMERIC=3D"POSIX"
LC= _TIME=3D"POSIX"
LC_COLLATE=3D"POSIX"
LC_MONETARY=3D"POSIX"
LC_ME= SSAGES=3D"POSIX"
LC_PAPER=3D"POSIX"
LC_NAME=3D"POSIX"
LC_ADDRESS= =3D"POSIX"
LC_TELEPHONE=3D"POSIX"
LC_MEASUREMENT=3D"POSIX"
LC_ID= ENTIFICATION=3D"POSIX"
LC_ALL=3D
 
Thank you in advance.
Andy.
------=_NextPart_000_0133_01C4C714.6110C9A0--