From: | Robert James <srobertjames(at)gmail(dot)com> |
---|---|
To: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Can LIKE under utf8 use INDEXes? |
Date: | 2009-07-22 22:50:07 |
Message-ID: | e09785e00907221550x163a7f49k4fd417de5d6797f3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-07-22 22:58:16 | Re: Select Column Auditing/Logging |
Previous Message | Sam Mason | 2009-07-22 22:49:13 | Re: Best way to import data in postgresl (not "COPY") |