[Desktop-packages] [Bug 1089302] Re: psql client by default in LATIN1 while should be UTF8
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
[Desktop-packages] [Bug 1089302] Re: psql client by default in LATIN1 while should be UTF8
Ah, that's what I thought. It's working as designed then, the psql encoding defaults to the current locale's encoding; otherwise you could not actually display non-ASCII characters from DB data. Please note that Ubuntu does not officially support non-UTF8 locales, so unless you have a strong reason not to, I'd advise to switch back to an UTF-8 locale. ** Changed in: postgresql-common (Ubuntu) Status: Confirmed => Invalid -- 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
[Desktop-packages] [Bug 1089302] Re: psql client by default in LATIN1 while should be UTF8
postgres@hostname:~$ locale LANG=en_US.iso88591 LANGUAGE=en_US:en LC_CTYPE="en_US.iso88591" LC_NUMERIC="en_US.iso88591" LC_TIME="en_US.iso88591" LC_COLLATE="en_US.iso88591" LC_MONETARY="en_US.iso88591" LC_MESSAGES="en_US.iso88591" LC_PAPER="en_US.iso88591" LC_NAME="en_US.iso88591" LC_ADDRESS="en_US.iso88591" LC_TELEPHONE="en_US.iso88591" LC_MEASUREMENT="en_US.iso88591" LC_IDENTIFICATION="en_US.iso88591" LC_ALL= ** Changed in: postgresql-common (Ubuntu) Status: Incomplete => 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
[Desktop-packages] [Bug 1089302] Re: psql client by default in LATIN1 while should be UTF8
Can you please copy&paste the output of "locale"? ** Changed in: postgresql-common (Ubuntu) Status: Confirmed => Incomplete -- 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: Incomplete 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
[Desktop-packages] [Bug 1089302] Re: psql client by default in LATIN1 while should be UTF8
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: postgresql-common (Ubuntu) Status: New => 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