Encoding on 8.0.4

From: Don Drake <dondrake(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Encoding on 8.0.4
Date: 2005-11-03 16:14:28
Message-ID: 6c21003b0511030814lf7a4da5gedcfa538c377e12d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I recently upgraded my DB from 7.4.3 to 8.0.4 and I've noticed the following
errors appearing in my serverlog:

2005-11-03 05:56:57 CST 127.0.0.1(38858) ERROR: Unicode characters greater
than or equal to 0x10000 are not supported
2005-11-03 06:04:09 CST 127.0.0.1(38954) ERROR: invalid byte sequence for
encoding "UNICODE": 0xe02d76
2005-11-03 06:04:21 CST 127.0.0.1(38964) ERROR: invalid byte sequence for
encoding "UNICODE": 0xe02d76
2005-11-03 06:11:35 CST 127.0.0.1(39072) ERROR: Unicode characters greater
than or equal to 0x10000 are not supported
2005-11-03 06:23:23 CST 127.0.0.1(39657) ERROR: invalid byte sequence for
encoding "UNICODE": 0xd40d
2005-11-03 08:10:02 CST 127.0.0.1(44073) ERROR: invalid byte sequence for
encoding "UNICODE": 0xe46973
2005-11-03 08:21:13 CST 127.0.0.1(44711) ERROR: Unicode characters greater
than or equal to 0x10000 are not supported
2005-11-03 08:26:36 CST 127.0.0.1(44745) ERROR: invalid byte sequence for
encoding "UNICODE": 0xc447
2005-11-03 08:40:59 CST 127.0.0.1(45087) ERROR: invalid byte sequence for
encoding "UNICODE": 0xdd20
2005-11-03 09:14:52 CST 127.0.0.1(46009) ERROR: Unicode characters greater
than or equal to 0x10000 are not supported

I never received these errors on when running 7.4.3. I used the default
encodings on 7.4.3 and I tried chaning client_encoding from sql_ascii to
UNICODE and I'm still seeing this. I'm storing in a text data type email
that contains other characterset characters.

Any ideas on how to resolve this?

-Don

--
Donald Drake
President
Drake Consulting
http://www.drakeconsult.com/
http://www.MailLaunder.com/

312-560-1574

Browse pgsql-sql by date

  From Date Subject
Next Message Judith Altamirano Figueroa 2005-11-03 16:17:52 date question
Previous Message Tom Lane 2005-11-03 15:17:35 Re: Slow query - SELECTing one row from 'big' table.