Re: Can LIKE under utf8 use INDEXes? - Mailing list pgsql-general

Robert James wrote:
> Thank you, Tom.  I guess I'm a bit confused about things here.  How can
> I find the locale of my database? (I wasn't able to find this in the docs).
> If I do have the locale set to 'C', do I loose anything by using utf8
> for all text fields?

use psql:

postgres=# \l+
                         List of databases
       Name      |   Owner   | Encoding |  Collation  |    Ctype    |
----------------+-----------+----------+-------------+-------------+
  postgres       | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |


output shortend ;-)

Cheers

Andy