Invalid Unicode character

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: Raw Message | Whole Thread | 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. "

Browse pgsql-jdbc by date

  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?