| From: | Marko Kreen <marko(at)l-t(dot)ee> |
|---|---|
| To: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: UNICODE |
| Date: | 2001-10-28 09:50:42 |
| Message-ID: | 20011028115041.A12320@l-t.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
On Sun, Oct 28, 2001 at 09:22:24AM +0100, Jean-Michel POURE wrote:
> Dear all,
>
> I am running PostgreSQL 7.1.2 with UNICODE support in production.
> Maybe I miss something about UNICODE:
> SELECT * FROM test WHERE source_content ILIKE '%accepté%' ---> returns
> nothing
> SELECT * FROM test WHERE source_content ILIKE '%accepte%' ---> returns
> nothing
>
> The same happens from ODBC, PHP and psql. Can you reproduce this?
1) Did you compile PostgreSQL with --enable-locale
2) Did you set correct locale for postmaster (LANG=xxx)
--
marko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-10-28 10:06:00 | Re: UNICODE |
| Previous Message | Emmanuel Guyot | 2001-10-28 09:36:56 | Date with timezone format |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-10-28 10:06:00 | Re: UNICODE |
| Previous Message | Jean-Michel POURE | 2001-10-28 08:22:24 | UNICODE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2001-10-28 10:06:00 | Re: UNICODE |
| Previous Message | Jean-Michel POURE | 2001-10-28 08:22:24 | UNICODE |