Encoding on 8.0.4

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

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/
http://www.mobilemeridian.com/
312-560-1574

Browse pgsql-performance by date

  From Date Subject
Next Message Qingqing Zhou 2005-11-03 23:30:12 Re: insert performance for win32
Previous Message Qingqing Zhou 2005-11-03 21:46:52 Re: insert performance for win32