patternsqlMinor
Setting locale for Chinese characters in Postgresql
Viewed 0 times
postgresqlchinesesettingforlocalecharacters
Problem
I am designing a Postgresql database that contains Chinese characters in certain tables (.e.g login, comments). Most tables are perfectly fine with ASCII characters.
From Postgresql Locale Support, the locale of the database can be set during creation. But setting a non-default
From Postgresql Locale Support, the locale of the database can be set during creation. But setting a non-default
C locale will degrade performance over sorting. Is it possible to specify locale per table or per column in Postgresql?Solution
You weren't far from finding it.
Here's the documentation you're looking for.
Yes you can define a specific locale for chosen columns (from 9.1 version).
Here's the documentation you're looking for.
Yes you can define a specific locale for chosen columns (from 9.1 version).
Context
StackExchange Database Administrators Q#180427, answer score: 2
Revisions (0)
No revisions yet.