Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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:

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group