From: | Reshat Sabiq <sabiq(at)purdue(dot)edu> |
---|---|
To: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
Cc: | Albin Blaschka <Albin(dot)Blaschka(at)bal(dot)bmlfuw(dot)gv(dot)at>, "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>, Reinhard Resch <Reinhard(dot)Resch(at)bal(dot)bmlfuw(dot)gv(dot)at>, Wilhelm Graiss <Wilhelm(dot)Graiss(at)bal(dot)bmlfuw(dot)gv(dot)at> |
Subject: | Re: German umlauts in pgadmin III |
Date: | 2003-10-21 05:10:56 |
Message-ID: | 3F94BFE0.2020800@purdue.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Actually, it's a wording issue:
ASCII: 7-bit
Extended ASCII (Latin 1): 8-bit
Personally, whenever i say ASCII, i usually mean Extended ASCII.
Regards.
Tino Wildenhain wrote:
> Hi Albin,
>
> Albin Blaschka wrote:
>
>> Hello,
>>
>> I am confronted with a little problem in pgadmin III:
>>
>> Table cells and comments on database objects are not properly
>> displayed if they contain a german umlaut.
>> The table cells just contain ", the comments (on tables,
>> for example) are completly empty.
>> In pgadmin II everything is okay, if I connect via
>> ODBC/Access to the tables, the umlauts are properly
>> displayed, too.
>>
>> Plattform for pgadmin: Win 2000
>> Database: Postgres 7.3.2 on Debian Linux Woody (3.0),
>> Database encoding SQL_ASCII
>
> ^^^^^^^^^^
>
> This is wrong. You cant have Umlauts with ASCII.
> If you input them, you violate the ASCII codeset,
> wich is 7 Bit only.
> You'll have to recode your data to ISO8859-1
> (Latin-1) or any superset (UNICODE)
> Then pgadminIII works as well as any other
> application. For migration or your apps
> they should just set their client_encoding
> to iso8859-1 then (if you choose UNICODE)
>
> Regards
> Tino Wildenhain
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Sincerely,
Reshat.
-------------------------------------------------------------------------------------------
If you see my certificate with this message, you should be able to send me encrypted e-mail.
Please consult your e-mail client for details if you would like to do that.
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2003-10-21 05:29:44 | Re: German umlauts in pgadmin III |
Previous Message | Tino Wildenhain | 2003-10-20 09:08:16 | Re: German umlauts in pgadmin III |