Re: [GENERAL] DB encoding, locale and indexes

2015-02-05 Thread Sterfield
2015-02-05 15:56 GMT+01:00 Tom Lane : > Sterfield writes: > > I'm a sysadmin working for an application that stores all its data in a > PG > > database. > > Currently, the cluster has its encoding set to UTF-8, and the locale > (both > > LC_COLLATE and LC_CTYPE) is set to 'en_US.UTF-8'. > > > I d

Re: [GENERAL] DB encoding, locale and indexes

2015-02-05 Thread Tom Lane
Sterfield writes: > I'm a sysadmin working for an application that stores all its data in a PG > database. > Currently, the cluster has its encoding set to UTF-8, and the locale (both > LC_COLLATE and LC_CTYPE) is set to 'en_US.UTF-8'. > I discovered recently that the indexes created on varchar f

[GENERAL] DB encoding, locale and indexes

2015-02-05 Thread Sterfield
Hi everyone, I'm a sysadmin working for an application that stores all its data in a PG database. Currently, the cluster has its encoding set to UTF-8, and the locale (both LC_COLLATE and LC_CTYPE) is set to 'en_US.UTF-8'. I discovered recently that the indexes created on varchar fields are not w