(repost) Invalid Unicode character

From: "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg>
To: <pgsql-general(at)postgresql(dot)org>
Subject: (repost) Invalid Unicode character
Date: 2002-04-15 08:40:10
Message-ID: 013e01c1e459$274dffd0$9b0e32d4@sirma.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-general by date

  From Date Subject
Next Message Nigel J. Andrews 2002-04-15 13:18:29 Re: How do I list all users and all databases.
Previous Message Damon Cokenias 2002-04-15 05:14:29 Re: remove warning