Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
D
D
DiIce2016-06-26 20:37:46
PostgreSQL
DiIce, 2016-06-26 20:37:46

How to change Postgresql server encoding?

Installed postgresql server on debian 8.
It set SQL_ANCII encoding by default
How to change server and database encoding to UTF8?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
V
Vladimir, 2016-06-27
@rostel

create with desired locale

/usr/lib/postgresql/9.5/bin/initdb -D /var/lib/postgresql/9.5/dbnew --locale=ru_RU.UTF-8

Similar questions
G
GrimJack2017-09-05 13:04:04
Why doesn't carbon parse the timestamp correctly? 2Reply
B
Bogdan2017-08-31 16:59:37
Autoincrement in INSERT INTO ... ON CONFLICT? 1Reply
E
EVOSandru62017-09-04 15:30:29
What is the best entity to pack the intermediate in the offer->intermediate_link->coupon? 0Reply
U
untley2017-09-08 14:29:30
How to find objects by radius? 1Reply
A
AntonIgin2017-09-10 20:38:54
Django and PostgreSQL: What to do with django.db.utils.ProgrammingError? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question