Re: Can LIKE under utf8 use INDEXes?

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(dot)wenk(at)netzmeister-st-pauli(dot)de> 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
>
>
>
>
>