3

I have a PostgreSQL 8.4 on Windows 7 machine, and my issue is that I have only the win1251 locale.

So when I create a database, I choose the UTF8 encoding and can select only lc_collate = Russian_Russia.Win1251. And when I get any errors when I use JDBC I get unreadable logs.

How can I set a locale like en_US.UTF8 or ru_RU.UTF8?

Mat
10.3k4 gold badges44 silver badges40 bronze badges
asked Sep 9, 2013 at 8:20

1 Answer 1

2

PostgreSQL 8.4 supports only one locales that is selected in installation time. You need to rerun initdb statement with different locales (but only one can be used) or you can migrate to 9.x version, that supports more locales.

answered Sep 9, 2013 at 13:13
2
  • I tried reinstall PostgreSQL 8.4 but not see any locale selection in instalation. For select locale i can not use one click installer? Commented Sep 10, 2013 at 5:44
  • Long time I didn't use a 8.4, but I remember, so there was a some possibilities - maybe your system missing some locales (postgres depends on system resources), maybe you use a some different installator. You can use a initdb command manually without reinstallation, but it needs some deeper knowledge stackoverflow.com/questions/5881845/… Commented Sep 10, 2013 at 11:00

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.