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

Re: UTF-8 and LIKE vs =

From: David Wheeler <david(at)kineticode(dot)com>
To: Joel <rees(at)ddcom(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-24 17:14:07
Message-ID: 022C59BA-F5F1-11D8-9420-000A95972D84@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-general
On Aug 23, 2004, at 10:25 PM, Joel wrote:

> If the locale machinery iw functioning correctly (and if I understand
> correctly), there ought to be a setting that would allow those to
> collate to the same point.

Bleh. There must be some distinction between them. It sounds like 
querying for synonyms.

> I'm not sure what the settings would be, or if it's fully funtional 
> yet.
> Maybe Tatsuo would know? (Hope he doesn't mind me CC-ing him.)
>
> So, what was the original language and text of the queries you started
> this thread with?

Korean, but the database I was using has data in 10 different languages 
in it, making any locale-specific collation useless.

Regards,

David

In response to

Responses

pgsql-general by date

Next:From: David WheelerDate: 2004-08-24 17:15:32
Subject: Re: UTF-8 and LIKE vs =
Previous:From: Oliver ElphickDate: 2004-08-24 17:13:59
Subject: Re: SELECT to an external file

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