Re: Can LIKE under utf8 use INDEXes?

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