Skip site navigation (1) Skip section navigation (2)

Re: opening utf8 file in pgadmin

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Claudia Kosny" <ckosny(at)gmx(dot)net>
Cc: <pgadmin-support(at)postgresql(dot)org>,"Dave Page" <dpage(at)postgresql(dot)org>
Subject: Re: opening utf8 file in pgadmin
Date: 2007-07-04 16:10:54
Message-ID: 013901c7be55$e6723350$c601a8c0@HP22720319231 (view raw or flat)
Thread:
Lists: 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 


In response to

pgadmin-support by date

Next:From: Dave PageDate: 2007-07-04 18:38:43
Subject: Re: Fw: opening utf8 file in pgadmin
Previous:From: Claudia KosnyDate: 2007-07-04 12:05:59
Subject: opening utf8 file in pgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group