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.wenk@netzmeister-st-pauli.de <mailto:a.wenk@netzmeister-st-pauli.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
>
>
>
>
>