[prev in list] [next in list] [prev in thread] [next in thread] 

List:       zope
Subject:    Re: [Zope] UTF8 encoding
From:       Garry Saddington <garry () schoolteachers ! co ! uk>
Date:       2008-06-18 15:50:57
Message-ID: 200806181650.57515.garry () schoolteachers ! co ! uk
[Download RAW message or body]

On Wednesday 18 June 2008 07:56, Tino Wildenhain wrote:
> Hi Garry,
>
> Garry Saddington wrote:
> > I am getting a few of this type of error only coming from Windows
> > machines, does anyone know how to sort this out?
> >
> > ProgrammingError: ERROR: invalid byte sequence for encoding "UTF8": 0xa3
> > 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". insert into departmentplanning (planningcategoryid,
> > taskid, subtasks, moneval, timescale, budget, success, subjectid,
> > teacherid) VALUES (1 , 186 , 'Identify suitable tasks and activities for
> > all G+T pupils and students ' , 'ADE- liaise with HS and GE' , 'JUL08
> > on' , 'SOme activities could be bought in ~ £50' , 'All G+T pupils and
> > students given opportunity for enhanced work' , 1787, 41 )
>
> You give us very little to base our suggestions on. From what I see
> it looks like you are using a RDBMS, seems to be Postgres, and
> the python binding (psycopg?) reports you this exeption. It also gives
> you hints about the reasons. Maybe you see if you can follow that?
> IIRC, recent ZSQL-driver for postgres allow for setting the encoding,
> you should use that, also setting this in the database for the
> user you are connecting with should be possible if everything else fails.
>
> In any case please try do give more details about your setup.
Thanks I traced it to a Postgres client_encoding problem. 
regards
garry
_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

[prev in list] [next in list] [prev in thread] [next in thread]