Encoding on 8.0.4 - Mailing list pgsql-performance

From Don Drake
Subject Encoding on 8.0.4
Date
Msg-id 6c21003b0511031435m3217574fk3013f41a4a265222@mail.gmail.com
Whole thread Raw
List 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

pgsql-performance by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: insert performance for win32
Next
From: "Qingqing Zhou"
Date:
Subject: Re: insert performance for win32