UTF8 in commandprompt (CMD) on XP fails. Tips?

From: Erwin Moller <erwin(at)darwine(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: UTF8 in commandprompt (CMD) on XP fails. Tips?
Date: 2008-08-15 10:44:23
Message-ID: 48A55E07.2080600@darwine.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi group,

I am trying to set up a testenvironment on my developmachine (XP Prof
SP3), using PHP as a scriptinglanguage to access Postgres (8.3).

I am working on a multilanguagal database, so I picked UTF8 as encoding
for this database.

Right now I am able to:
1) Send information (Including UTF8) from a html form to PHP.
2) Pick up the info in PHP, and insert it into Postgres
3) Get the info out of Postgres, and display it right as HTML in a
browser. (Using HTML strict and encoding UTF-8 of course).

So far so good.

My problem started with using psql.
psql complained to me it couldn't display all characters right when I
started my session.
So I changed the encoding to UTF8, using:
\encoding UTF8

Now I can query from commandline, but many UTF8 characters are displayed
wrong.
(NOT if I use a webbrowser with UTF8, but only commandline)

I read something on the net about using a different font and change my
codepage.
I did this (without succes):
1) Changed the font of the dosshell to Lucida Console
2) Gave the command chcp 65001

Now, if I give a simple SQL command, it responds with:
Not Enough Memory.

I am not sure if this is a Postgres problem or Microsoft (probably the
latter)

Anyway, Is it possible to have psql working with UTF8 in a windows
commandprompt?

TIA!

Regards,
Erwin Moller

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Finneid 2008-08-15 13:21:34 table name length restriction
Previous Message Fuzzygoth 2008-08-15 10:08:31 Delete across 5 Joined tables