Data type of table1.c1 is bytea. That column stores binary data. The following matchings do not work. What is the right syntax?
select c1 ~ E'\000' from table1;
select c1 LIKE E'%\000%' from table1;
ERROR: invalid byte sequence for encoding "UTF8": 0x00
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
pgsql-general by date
|Next:||From: seiliki||Date: 2010-02-27 09:17:38|
|Subject: regexp_replace: LF, CR, or tab|
|Previous:||From: Greg Smith||Date: 2010-02-27 08:25:42|
|Subject: Re: Automatic index advisor?|