On 16/01/2020 17:24, Daniel Verite wrote:
> Looking at these columns which are of type text but do not
> contain words of any particular language, there's probably
> no point in using a linguistic-aware collation for them.
>
> If you maintain the database schema, what you could do to avoid
> the dependency on the OS collation and stay clear of the particular
> upgrade difficulty of collations is to use COLLATE "C" for this kind of
> field, as opposed to the default collation of the database.
> As a bonus, operations with the "C" collations tend to be faster,
> sometimes even much faster.
Good to know, thanks Daniel!