| From: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
|---|---|
| To: | Robert James <srobertjames(at)gmail(dot)com> |
| 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:45:41 |
| Message-ID: | 4A679695.8070903@netzmeister-st-pauli.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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:49:13 | Re: Best way to import data in postgresl (not "COPY") |
| Previous Message | Sam Mason | 2009-07-22 22:39:42 | Re: How would I get information regarding update when running for a long time? |