Horton

Re: UNICODE

Marko Kreen <marko@l-t.ee>

View thread View on postgr.es
From: Marko Kreen <marko@l-t.ee>
To: Jean-Michel POURE <jm.poure@freesurf.fr>
Cc: pgsql-hackers@postgresql.org
Date: 2001-10-28T09:50:42Z
Lists: pgsql-hackers, pgsql-general 
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