How to use a db in UTF-8 encoding under Windows - Mailing list pgsql-novice

From lists@kambanaria.org
Subject How to use a db in UTF-8 encoding under Windows
Date
Msg-id 42523.88.203.201.242.1261237362.squirrel@webmail.openintegra.com
Whole thread Raw
List pgsql-novice
Hi everyone,

I have a problem with a 8.2.15 PG database under Linux when I try to
connect from a 8.2.15 Windows client (psql)

As per the Notice for Windows users I set the font of cmd.exe to Lucida
console and then change the codepage to UTF-8:
chcp 65001
Then when I try to make a select or any \d command I get "Not enough memory"

I tried with setting the codepage to 1251 (that is the native on Windows)
and I can do all selects, insert - however the ecnoding is wrong and I
cannot actually use the db as it contains non ASCII symbols.

I see that there was a bug for this. Is there a work around?

Kind regards:
al_shopov

pgsql-novice by date:

Previous
From: Marco Craveiro
Date:
Subject: Re: Problems with stored procedure (function)
Next
From: Mladen Gogala
Date:
Subject: Re: Conditionally executing multiple statements in series as single SQL statement