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 C locale will degrade performance over sorting. Is it possible to specify locale per table or per column in Postgresql?


1 Answer 1


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).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.