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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-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

Browse pgsql-admin by date

  From Date Subject
Next Message Tatsuo Ishii 2001-10-29 00:58:25 Re: UNICODE
Previous Message mlw 2001-10-28 23:11:40 Re: Ultimate DB Server

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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