Public bug reported: 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. ** Affects: postgresql-common (Ubuntu) Importance: Undecided Status: Confirmed -- 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: Confirmed 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