Re: Can LIKE under utf8 use INDEXes?

Robert James wrote:
> Thanks - I don't show any locale:
> rbt_development=> \l
> List of databases
> Name | Owner | Encoding
> ----------------------------+---------------------+----------
> rbt_development | rbt | UTF8
> ...

ahm - you are running pg 8.2. There I think the + option is not
available (\l+). So if you use a debian based system and installed it
via the package manager apt or aptitude you could give this a try:

/usr/lib/postgresql/8.2/bin/pg_controldata \
/var/lib/postgresql/8.2/main/ |grep LC

This should output something like:

LC_COLLATE: de_DE.UTF-8
LC_CTYPE: de_DE.UTF-8

I hope this helps a little ...

Cheers

Andy

P.S.: top posting is ugly ;-)

>
> On Wed, Jul 22, 2009 at 6:45 PM, Andreas Wenk
> <a(dot)wenk(at)netzmeister-st-pauli(dot)de <mailto: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
>
>
>
>
>