UTF8 in commandprompt (CMD) on XP fails. Tips?
От | Erwin Moller |
---|---|
Тема | UTF8 in commandprompt (CMD) on XP fails. Tips? |
Дата | |
Msg-id | 48A55E07.2080600@darwine.nl обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: