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

Re: UNICODE

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: jm(dot)poure(at)freesurf(dot)fr
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UNICODE
Date: 2001-10-29 00:57:05
Message-ID: 20011029095705G.t-ishii@sra.co.jp (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
I'm not sure what you are expecting but...

> SELECT * FROM test WHERE source_content ILIKE '%accept%';
  ---> returns a record

> SELECT * FROM test WHERE source_content ILIKE '%accepté%'
  ---> returns a record

> SELECT * FROM test WHERE source_content ILIKE '%accepte%'
  ---> returns 0 record

So all of above seem to work fine for me.

$ pg_config --configure
--prefix=/usr/local/pgsql --enable-multibyte=EUC_JP --enable-unicode-conversion --with-tcl --with-perl --enable-syslog --enable-debug --with-CXX --with-java
$ pg_config --version
PostgreSQL 7.1.3
--
Tatsuo Ishii

In response to

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

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 2001-10-29 00:58:25
Subject: Re: UNICODE
Previous:From: David FordDate: 2001-10-29 00:19:01
Subject: Re: [patch] helps fe-connect.c handle -EINTR more gracefully

pgsql-admin by date

Next:From: Tatsuo IshiiDate: 2001-10-29 00:58:25
Subject: Re: UNICODE
Previous:From: mlwDate: 2001-10-28 23:11:40
Subject: Re: Ultimate DB Server

pgsql-general by date

Next:From: Tatsuo IshiiDate: 2001-10-29 00:58:25
Subject: Re: UNICODE
Previous:From: Tatsuo IshiiDate: 2001-10-29 00:56:57
Subject: Re: UNICODE

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