Skip site navigation (1) Skip section navigation (2)

Re: UNICODE

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-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


In response to

  • UNICODE at 2001-10-28 08:22:24 from Jean-Michel POURE

Responses

  • Re: UNICODE at 2001-10-28 10:06:00 from Jean-Michel POURE

pgsql-hackers by date

Next:From: Jean-Michel POUREDate: 2001-10-28 10:06:00
Subject: Re: UNICODE
Previous:From: Jean-Michel POUREDate: 2001-10-28 08:22:24
Subject: UNICODE

pgsql-admin by date

Next:From: Jean-Michel POUREDate: 2001-10-28 10:06:00
Subject: Re: UNICODE
Previous:From: Emmanuel GuyotDate: 2001-10-28 09:36:56
Subject: Date with timezone format

pgsql-general by date

Next:From: Jean-Michel POUREDate: 2001-10-28 10:06:00
Subject: Re: UNICODE
Previous:From: Jean-Michel POUREDate: 2001-10-28 08:22:24
Subject: UNICODE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group