How does postgresql modify character ordering?

Environment:

PostgreSQL 9.4.1 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit

question:

in the current Linux system, the character sorting rule of the database is en_US.utf8, so that the Chinese sorting is not the desired result. We want to change the sorting rule of the whole database to zh_CN.UTF-8, to ensure the sorting reliability.

but when you create a database, you cannot specify that the collcollate, use pgAdmin3 to create the database, and the character sort drop-down box does not have this option.

how do I set up the zh_CN.UTF-8 collation so that I can use it when I create a new database?
find the inidb way to specify locale, on the Internet. Can I only reinitialize the tablespace?

Postgresql

Apr.11,2021

it is recommended that you use the psql console to execute CREATE DATABASE statements.

in addition, the LC_COLLATE option is subject to the ENCODING option and the system's own locale. For more information, you can take a look at the notes on LC_COLLATE and LC_CTYPE in PG's official manual ( Notes )

https://www.postgresql.org/do.

Previous: Questions about the echarts dashboard.

Next: The array with _ _ ob__: Observer in Vue cannot be fetched from it.

Centos7shell postgres login failed
Baidu said that there is a problem with the verification method in the file var lib pgsql 9.5 data pg_hba.conf, but the reason for changing the verification method is to use the command psql-U postgres-d mydjango-p 5432-h 127.0.0.1 to log in directl...

Nginx centos django python postgresql

Feb.26,2021
Failed to create a project using Vue.js in python3 virtual environment in centos system
vue chromedriver@2.37.0 ...

Vue.js django centos postgresql virtualenv

Feb.28,2021
Can update operate in batches like insert in sql database?
because batch update operations are always involved recently, I don t know if batch operations can be performed, so we can only update, one by one in the loop , so I d like to ask whether there is a sql statement in the sql database that enables updat...

Insert update mysql sql postgresql

Feb.28,2021
Type object 'Meta' has no attribute' model'
(venv3_ETC) [root@iZwz9hbv3lrr68d8bo5dvpZ goods]-sharp python views.py Traceback (most recent call last): File "views.py ", line 5, in < module > from .serializer import GoodsSerializer ModuleNotFoundError: No module named _ main__.serializer ; ...

Vim postgresql centos django python

Mar.01,2021
With regard to the error about the introduction of modules in the same directory, the custom module cannot be read by django,2.0 's setting.pyri installed _ APPS?
sys.path.insert(0,BASE_DIR) , sys.path.insert(0,os.path.join(BASE_DIR, db_tools ))sys.path.insert(0,os.path.join(BASE_DIR, apps ))sys.path.insert(0,os.path.join(BASE_DIR, extra_apps )) :shell from goods.models import Goods :python models.py:Tra...

Postgresql nginx django python

Mar.01,2021
How does django solve the problem of creating users in bulk?
A registration function. The function of accessing the registered url, url is to read the user names and passwords of 500 users from the excel file, read out a piece of data, run the create_user function at a time to create a user, but this will cause t...

Django postgresql redis

Mar.03,2021
How to fetch data by only one of the two fields with different values in group by grouping in SQL
Table: ID name value time 1 A 3 2018-1-1 1 A 4 2018-4-4 2 B 6 2018-1-2 3 C 7 2018-1-3 3 C 9 2018-4-6 how to group by ID and only take the most recent value of time (time) under the same ID and name: such as: ID name value time 1 A 4 2018-4-...

Sql postgresql

Mar.04,2021
Postgresql bulk insert
there are two minor problems: 1. The insertion time of postgresql is the same when executing batches. Is there any way to make them inconsistent? 2. When duplicate data already exists in the library, the entire execution fails. For example, 10 entries ...

Postgresql

Mar.04,2021
Is there any simple way to merge two tables in different formats in two databases?
two programs merge, each has its own database, want to merge this piece together, do not intend to change the code, this will change bigger, there is no simple way to directly modify the database, I intend to first merge the database, such as table An an...

Postgresql

Mar.04,2021
In the HTAP scenario with a large data base, will you use self-increasing id as the primary key or UUID?
Longge question post: in HATP scenarios with large data bases, would you use self-increasing id as primary key or UUID? Or what do you suggest? Why? ...

Mysql postgresql

Mar.07,2021
Why does win10 run pg4Admin flicker or report a fatal error unable to open the default browser? Is there any solution?
download PostgreSQL10.3 and open pg4Admin and then flicker or fail to open the default browser when you report an error. I tried to uninstall and reinstall many times without solving it, but the SQL Shell interface is available. tried to download va...

Internet-explorer windows sql postgresql

Mar.10,2021
How to use postgresql timestamp
1 is the original data in the table a numeric value or a formatted time string for Magi Postgresql timestamp? 2, if it is a formatted string, is his own sorting performance very poor? 3, if it is a numerical value, can you check it directly according t...

Postgresql

Mar.13,2021
Why the length of the int4 type of postgresql can reach 10 bits
two questions: Why the length of the int4 type of postgresql can reach 10 bits, but it is set to 32 bits in the attribute The int4 type length of postgresql is set to 32 bits by default, so why can t it be modified? it is still 32 bits after modif...

Integer db data-type postgresql

Mar.13,2021
How to convert tables to CSV? in ubuntu virtual machine by postgres
how does postgres convert tables to CSV? in ubuntu virtual machines google found COPY ( SELECT name, category_name FROM products LEFT JOIN categories ON categories.id = products.category_id ) TO path to output.csv WITH csv; but using this ...

Ubuntu csv postgresql

Mar.13,2021
Django relation "accounts_user" does not exist
my django project Subject accounts courses views.py tests test_models.py subject test_models.py: from django.core.urlresolvers import reverse from django.test import TestCase from .models import MultiSub...

Postgresql django python

Mar.14,2021
How to set the primary key self-increment when creating a table in a postgresql database using navicat?
No place was found. ...

Sql java navicat postgresql

Mar.16,2021
PHP pdo links to postgresql database. Json is used in where conditions to report errors.
has recently been using the json format of postgresql database and found that pdo query reported an error the source code is as follows <?php PDO $pdo = new PDO("pgsql:host=127.0.0.1;port=5432;dbname=postgres","postgre...

Php postgresql

Mar.16,2021
Will it be faster for JAVA to check 5 sql with 5 threads than 5 sql with 1 thread?
Project background: the intranet OLAP application, specifically, is a variety of statistical charts for leaders to see. The project concurrency is small, so multiple threads can be used for a single request. The bottleneck is that the statistics of SQL ...

Java postgresql database

Mar.17,2021
How to get the accumulated data that satisfies a certain value from the database
for example: < table > < thead > < tr > < th > id < th > < th > num < th > < tr > < thead > < tbody > < tr > < td > 1 < td > < td > 1 < td > < tr > < tr > < td > 2 < td > < td > 20 < td > < tr > < tr > < td > 3 < td > < td > 30 < ...

Postgresql mysql database

Mar.20,2021
Php programming error Uncaught SyntaxError: Unexpected identifier?
php version is 5.6.36 Magi Apache server version 2.4.3Jet Postgresql version 9.5.1 read other people s code, in theory, it will be no problem if it is deployed directly. initially suspects that there is something wrong with the local php environment ...

Php postgresql apache

Mar.22,2021