On Tue, Mar 20, 2007 at 09:06:25PM +0100, Claus Guttesen wrote: > >DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding > >"UTF8": 0x92 > >[for Statement "INSERT INTO longdescs (bug_id, who, bug_when, thetext, > >isprivate) > > Try to modify client_encoding in postgresql.conf to utf8 and restart your > db. The data is apparently not UTF-8 so client_encoding needs to be set to something else. 0x92 is a hint that the encoding might be Windows-1252 or Windows-1250 since that byte represents the right single quotation mark in those encodings; that's a common character in data that originated in Windows. Also, client_encoding can be set by the client without having to restart the backend. -- Michael Fuhr
