Re: Can LIKE under utf8 use INDEXes?

[Robert James <srobertjames@xxxxxxxxx>]

Thanks - I don't show any locale:

rbt_development=> \l
  List of databases
  Name | Owner | Encoding
----------------------------+---------------------+----------
 rbt_development | rbt | UTF8
 ...

On Wed, Jul 22, 2009 at 6:45 PM, Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

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