Hi,This is correctly diagnosed, non-ascii data in a SQL_ASCII encoded database will not be shown because the server doesn't know how to encode it in Unicode.
I think I have a similar issue... A pgAdmin III user contacted me with the
question why they can't see the data in Russian and how to to solve the
problem. I queried them for more information. I think their data must be
encoded in some other encoding (e.g. KOI8-R) and when it gets to the
client side, it's not converted.
This is fixed for HEAD and BRANCH.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match