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
