| From: | "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Invalid Unicode character |
| Date: | 2002-04-12 18:27:14 |
| Message-ID: | 003601c1e24f$abb3ddf0$9b0e32d4@sirma.bg |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi,
when performing a "vacuum analyze" on a table containing some test data in
Unicode I get:
"ERROR: Invalid Unicode character sequence found (0xed5c30)"
the DB is 7.2 and the data was inserted with the 7.2dev jdbc driver
the Unicode strings being inserted are
"\u65e5\u672c\u8a9e\u6587\u5b57\u5217" (japanese) and
"\u0915\u0932\u094d\u0907\u0928\u0643\u0637\u0628\u041a\u0430\u043b\u0438\u0
43d\u0430" (cyrillic)
searching the archives I found messages that this could happen in pre-7.2
versions because Unicode validation on the inserted data was not performed -
so, any ideas why I get this error when the data was analyzed and not when
it was inserted
thanx,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zoltan Fulop | 2002-04-12 20:12:48 | Using postgresql connection in distributed environment |
| Previous Message | Vernon Wu | 2002-04-12 01:58:53 | Re: raw data broken in 7.2 driver? |