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?