Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using default PostgreSQL install on Windows XP. Unfortunately localized (non-english) messages are not displayed correctly neither in SQL Shell nor in diagnostic messages during app run-time.

What can be done to make Postgre show messages correctly?

Sample message:

Alt text

share|improve this question
up vote 1 down vote accepted

SET CLIENT_ENCODING TO 'value'; is a typical solution. Please, read the docs for more.

share|improve this answer
Also note that in both cases your terminal (or whatever your app display is) needs to support the encoding you specify. – voretaq7 Mar 19 '12 at 15:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.