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
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 |