Postgres Pro
Downloads
Home   >   mailing lists

Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From Tom Lane
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 23145.1093302534@sss.pgh.pa.us
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
Responses Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
List pgsql-general
Tree view 
David Wheeler <david@kineticode.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

pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: Tim Penhey
Date:
Subject: Re: Python and 8.0 beta