Re: invalid byte sequence for encoding

On sön, 2009-09-13 at 18:51 +0200, Daniel Schuchardt wrote:
> UPDATE belzeil_frei SET bz_zubez= '*', bz_zubez_rtf=
> '{\\rtf1\\ansi\\deff0{\\fonttbl{\\f0\\fnil\\fcharset0
> Arial;}}\r\n\\viewkind4\\uc1\\pard\\lang1031\\fs20 *\r\n\\par }\r\n\0'
> WHERE dbrid=295116
>
> Result : ERROR:  invalid byte sequence for encoding "WIN1252": 0x00
>
> In that example i try to insert a "*" with rtf-encoding.
>
> i have the same problem with SQL_ASCII

Maybe you want to use the bytea type instead, because you appear to be
storing bytes rather than characters.