Re: Accented characters column names not displayed

From: Dave Page <dpage(at)postgresql(dot)org>
To: Andrus <eetasoft(at)online(dot)ee>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Accented characters column names not displayed
Date: 2006-11-03 09:50:12
Message-ID: 454B10D4.2050205@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Andrus wrote:
> To reproduce, run the following code in query window:
>
> create table test ( ä text );
> select * from test;
>
> Observed in output pane:
>
> No column name.
> Column type "text" is only partially visible.

I see both.

>
> Observed in object browser:
>
> Column with empty name is shown.
>
> Observed in SQL pane:
>
> CREATE TABLE tt
> (
> text
> )

I see:

CREATE TABLE test
(
"ä" text
)
WITHOUT OIDS;
ALTER TABLE test OWNER TO postgres;

> Observed when tryind to delete column in object browser:
>
> ---------------------------
> pgAdmin III
> ---------------------------
> An error has occurred:
>
> ERROR: syntax error at end of input at character 28

And the column gets deleted just fine!

What is your database encoding? I tested with latin1 and utf8.

Regards, Dave.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andrus 2006-11-03 11:21:12 Re: Accented characters column names not displayed
Previous Message Dave Page 2006-11-03 09:36:49 Re: Issue in "Find and Replace"