Thanks. I never intentionally changed the system locale but it is fixed now. For those who are interested, this is how you do it. Change in /etc/default/locale the line LANG="en_US.iso88591" to LANG="en_US.utf8" and all new shells will automatically use this locale
-- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/1089302 Title: psql client by default in LATIN1 while should be UTF8 Status in “postgresql-common” package in Ubuntu: Invalid Bug description: psql from postgresql-client-common 129ubuntu1 is by default in LATIN1 encoding while it should be in UTF8. This results in problems such as: dbname=# select * from tname; ERROR: character 0xc487 of encoding "UTF8" has no equivalent in "LATIN1" dbname=# set client_encoding to 'UTF8'; SET dbname=# select * from tname; ... All databases in postgresql are created by default in UTF8 (or UTF-8 whatever is more appropriate) so the client should also have the same default setting. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1089302/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
