Thread: pgadmin doesn't show field contents

pgadmin doesn't show field contents

From
kaeptn haddock
Date:
Dear List

We have databases in SQL_ASCII (I know, uft-8 would be better).
In Windows, pgadmin works fine.
In Ubuntu, pgadmin doesn't show field content when fields contain
special characters such aus umlaute.

Is this a bug, and is there a workaround (other than changing the
encoding of the db?)

Many thanks for any help
best regards
pl



Re: pgadmin doesn't show field contents

From
"Dave Page"
Date:
On Thu, Jul 17, 2008 at 7:09 AM, kaeptn haddock
<kaeptn.haddock@gmail.com> wrote:
> Dear List
>
> We have databases in SQL_ASCII (I know, uft-8 would be better).
> In Windows, pgadmin works fine.
> In Ubuntu, pgadmin doesn't show field content when fields contain
> special characters such aus umlaute.
>
> Is this a bug, and is there a workaround (other than changing the
> encoding of the db?)

Well the problem with SQL_ASCII is that pgAdmin really has no clue how
to interpret anything other than chars 0 - 127 (pure 7 bit ASCII), so
what you get is largely down to how the OS/Widget set decide to
interpret such characters.

The only real fix is to convert to another encoding, such as utf-8.
You might just have to bite the bullet and give it a try.

-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com