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
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-26 16:36:20
Message-ID: 0F9BE143-F77E-11D8-BD80-000393D9369E@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-general
On Aug 24, 2004, at 6:58 PM, Joel wrote:

> Sorry, I guess I wasn't clear. It's almost directly corollary to
> ignoring case. (Almost, but not quite.) Kind of like querying with 
> "TEST"
> and getting records with "test".

How interesting!

> Which means that the correct solution now is beyond the question of 
> what
> did the vendor think you would want. No way the vendor is going to be
> willing to think you really want that, in spite of the number of people
> who want precisely that. We don't yet have a mechanism that works for
> general multiple language solutions.

Right, except for "no locale" (is C locale the same thing?).

> At this point in time, "no locale" is probably close to best practice,
> but it leaves you a lot of work.

It does?

Regards,

David


In response to

pgsql-general by date

Next:From: David WheelerDate: 2004-08-26 16:39:23
Subject: Re: UTF-8 and LIKE vs =
Previous:From: Tom LaneDate: 2004-08-26 16:34:29
Subject: Re: R: space taken by a row & compressed data

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