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