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 : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
