How to use a db in UTF-8 encoding under Windows

From: lists(at)kambanaria(dot)org
To: pgsql-novice(at)postgresql(dot)org
Subject: How to use a db in UTF-8 encoding under Windows
Date: 2009-12-19 15:42:42
Message-ID: 42523.88.203.201.242.1261237362.squirrel@webmail.openintegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2009-12-20 06:57:03 Re: Conditionally executing multiple statements in series as single SQL statement
Previous Message Marco Craveiro 2009-12-19 14:19:17 Re: Problems with stored procedure (function)