Re: opening utf8 file in pgadmin - Mailing list pgadmin-support

From Hiroshi Saito
Subject Re: opening utf8 file in pgadmin
Date
Msg-id 013901c7be55$e6723350$c601a8c0@HP22720319231
Whole thread Raw
In response to opening utf8 file in pgadmin  (Claudia Kosny <ckosny@gmx.net>)
List pgadmin-support
Hi.

You are right.!
http://winpg.jp/~saito/pgAdmin/frmQuery_patch.txt
http://winpg.jp/~saito/pgAdmin/frmQuery_bug_fix.png
This problem is repaired in this patch. I wait for the review of Dave.
However, Dave may be a travel at PGDAY.IT...
I found other problems relevant to it. It is the reason.
Please wait for a while. sorry.

Thanks!

Regards,
Hiroshi Saito


> Hi there
>
> I have a file with sql insert commands which is utf8 encoded.
> If I copy the contents of the folder into the SQL-window of pgadmin, everything is fine. 
> But if I use the file>open command to open this
> file the utf8 characters are incorrectly encoded
> For instance the german umlaut ü (ue) is transformed to ü.
>
> The database is utf8 encoded.
> I use pgadmin 1.6.3, postgres 8.2 on Windows XP.
>
> In the preferences I have enabled the option 'read and write unicode utf8 files'.
>
> Is there a setting that I am missing?
>
> Thanks for any tips
>
> Claudia
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match 



pgadmin-support by date:

Previous
From: Claudia Kosny
Date:
Subject: opening utf8 file in pgadmin
Next
From: Dave Page
Date:
Subject: Re: Fw: opening utf8 file in pgadmin