Thread: opening utf8 file in pgadmin

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

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