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

Re: UTF-8 and LIKE vs =

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Wheeler <david(at)kineticode(dot)com>
Cc: Ian Barwick <barwick(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-23 23:08:54
Message-ID: 23145.1093302534@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
David Wheeler <david(at)kineticode(dot)com> writes:
> Is the encoding check fixed in 8.0beta1?

[ looks back at discussion... ]  Actually I misremembered --- the
discussion was about how we would *reject* legal UTF-8 codes that are
more than 2 bytes long.  So the code is broken, but not in the direction
that would cause your problem.  Time for another theory.

Is the problem query using an index?  If so, does REINDEX help?

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Tim PenheyDate: 2004-08-23 23:12:35
Subject: Re: Python and 8.0 beta
Previous:From: David WheelerDate: 2004-08-23 23:01:47
Subject: Re: UTF-8 and LIKE vs =

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