Am Dienstag, 20. März 2007 20:34 schrieb Karthikeyan Sundaram: > Hi, > > I am using postgres 8.2.3. I have recently converted my database from > sql-ascii to UTF8. I have a portal which calls a perl program to insert > the data into the database. > > While inserting, I am getting an error message > > 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) > > > How can I set the client encoding in perl. Can somebody help me? > > Regards > skarthi
After the connection is done send set client_encoding to '<Encoding Perl is using>' to the server. The server then will convert the strings back and forward for you. Se manual chapter 21.2 Character Set Support for more details. Best regards Ivo > > _________________________________________________________________ > Get a FREE Web site, company branded e-mail and more from Microsoft Office > Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings