[Pypgsql-devel] [ pypgsql-Bugs-967375 ] Incomplete utf-8 support

[SourceForge.net <no...@so...>]

Bugs item #967375, was opened at 2004-06-05 21:04
Message generated for change (Comment added) made by ballie01
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=967375&group_id=16528

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Ben Burton (bab)
Assigned to: Nobody/Anonymous (nobody)
Summary: Incomplete utf-8 support

Initial Comment:
Hi.  Again from the debian BTS (#232217). - Ben. 
 
I just found this: 
 
 /usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py in 
execute(self=<pyPgSQL.PgSQL.Cursor instance>, 
query='INSERT INTO sessiondata (session,object,key,valu...UES 
(%(param1)s,%(param2)s,%(param3)s,%(param4)s)', 
*parms={'param1': "'00E003088E7A'", 'param2': "'userinfo'", 
'param3': "'surname'", 'param4': 
"'Hj\xf0\xae\xae\xa5v\xe5\xa7\xa2 type='"}) 
 3070           self.conn.__dict__["inTransaction"] = 0 
 3071           self.conn._Connection__closeCursors() 
 3072       raise OperationalError, msg 
 3073   except InternalError, msg: 
 3074       # An internal error occured.  Try to get to a sane 
state. 
global OperationalError = <class libpq.OperationalError> 
msg = <libpq.OperationalError instance> 
OperationalError: ERROR:  Unicode >= 0x10000 is not supported 
 
which seems to say that PgSQL only supports a subset of the 
unicode character set. This is a bit of a problem for us since we 
have customers using those (which is how I got that backtrace). 

----------------------------------------------------------------------

>Comment By: Billy G. Allie (ballie01)
Date: 2004-07-31 16:32

Message:
Logged In: YES 
user_id=8500

This sounds like the error is coming from PostgreSQL and
that PostgreSQL could not handle the Unicode value.  Have
you tried sending the query directly to the database using psql?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=967375&group_id=16528