Re: invalid byte sequence for encoding

[Daniel Schuchardt <d.schuchardt@xxxxxxxxxxxxx>]

Hi Thomas,

thanks a lot we will check out that parameter. But if i understand it in 
 the correct way that parameter will turn off all escape quoting.

I have to check out,

thanks a lot.

Thomas Kellerer schrieb:
> 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


--
Daniel Schuchardt
/Softwareentwicklung/

/http://www.prodat-sql.de/

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general