| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Maximilian Tyrtania <maximilian(dot)tyrtania(at)onlinehome(dot)de> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Distinct oddity |
| Date: | 2009-05-10 02:58:22 |
| Message-ID: | 20090510025822.GD5365@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Maximilian Tyrtania wrote:
> am 08.05.2009 16:55 Uhr schrieb Rob Sargent unter robsargent(at)rocketmail(dot)com:
> > and what locale are you running in?
>
> lc_collate | de_DE
> | Shows the collation order locale.
> lc_ctype | de_DE
> | Shows the character classification and case conversion locale.
>
> The encoding is UTF-8.
Note that the de_DE locale uses Latin9 encoding, which is incompatible
with UTF8. I'd try checking if the problem is reproducible in
de_DE.utf8 (you need to create a new database for testing, obviously).
If it's not, then the incompatible locale definition is causing the
problem.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2009-05-10 10:57:44 | Re: RAISE NOTICE |
| Previous Message | Glenn Maynard | 2009-05-09 19:15:51 | Re: Distinct oddity |