http://bugzilla.opensuse.org/show_bug.cgi?id=965340 Bug ID: 965340 Summary: Change default locale for postgresql to UTF-8 Classification: openSUSE Product: openSUSE Tumbleweed Version: 2015* Hardware: Other OS: Other Status: NEW Severity: Normal Priority: P5 - None Component: Other Assignee: max@suse.com Reporter: mrueckert@suse.com QA Contact: qa-bugs@suse.de Found By: --- Blocker: --- just changing the POSTGRES_LANG or the in script default to UTF-8 would fix that. we have default locales for other things in the postgresql.conf also set to UTF-8 and this would make it more consistent. also with the current defaults you cant create UTF-8 based DBs from template1 but have to use template0. so you would need to maintain 2 templates based on the encoding. with current defaults: ``` psql (PostgreSQL) 9.4.5 List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+-----------+---------+-------+----------------------- postgres | postgres | SQL_ASCII | C | C | template0 | postgres | SQL_ASCII | C | C | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | SQL_ASCII | C | C | =c/postgres + | | | | | postgres=CTc/postgres (3 rows) ``` with the default locale changed to en_US.UTF-8 (i just set POSTGRES_LANG for testing) ``` psql --version ; psql -l psql (PostgreSQL) 9.4.5 List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (3 rows) ``` Thoughts? -- You are receiving this mail because: You are on the CC list for the bug.