Re: Invalid byte sequence for encoding "UTF8": 0xedbebf - Mailing list pgsql-general

BRUSSER Michael wrote:
> Is there a way to find the records with the text field containing
Unicode bytes "0xedbebf"?
>
> Unfortunately this is a very old version 7.3.10

This should work on 7.3 (according to the documentation):

SELECT id FROM nlsdata WHERE position('\360\235\204\236'::bytea IN
val::bytea) = 1;

Here "val" is the column containing the values in question.

Yours,
Laurenz Albe