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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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