Re: invalid byte sequence for encoding

Daniel Schuchardt wrote on 13.09.2009 18:51:
> 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


Sounds to me as if you need to set standard_conforming_strings to true in the postgresql.conf

http://www.postgresql.org/docs/8.4/static/runtime-config-compatible.html#GUC-STANDARD-CONFORMING-STRINGS

Thomas