View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 07:37 PM
Dave Page
 
Posts: n/a
Default Re: Accented characters column names not displayed

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.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote