| From: | "Claus Guttesen" <kometen(at)gmail(dot)com> |
|---|---|
| To: | "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92 |
| Date: | 2007-03-20 20:06:25 |
| Message-ID: | b41c75520703201306w2a1e08a5n41c86395f778d25b@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
> 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)
Try to modify client_encoding in postgresql.conf to utf8 and restart your db.
regards
Claus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-03-21 00:01:33 | Re: WAL based backup/recovery clarifications |
| Previous Message | Ivo Rossacher | 2007-03-20 20:03:12 | Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Judith | 2007-03-20 23:54:47 | Substitute |
| Previous Message | Ivo Rossacher | 2007-03-20 20:03:12 | Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92 |