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
N
nezzard2017-10-24 21:52:50
How to cut string for fio? 1Reply
S
Schoolboy.2015-08-22 08:20:07
How to edit records in a database using phpPgAdmin? 0Reply
K
Ken Jee2015-08-22 18:08:09
Which algorithm (PHP function) is better to get the hash of a string for subsequent database comparison? 2Reply
S
stayHARD2015-08-29 13:49:10
How to properly update postgresql? 1Reply
V
vaflya2020-01-08 22:40:01
How to search a table in Postgres with different case? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question