RE: [Pypgsql-users] unicode?

[Mark M. <mar...@mc...>]

Gerhard, thank you for the workaround.  That's very helpful.

I don't have a pressing need to store Unicode.  How I came across the issue
is somewhat strange.  I was manipulating xml with minidom and found that the
strings it squirts out with toxml() are Unicode strings.  When I tried to
insert those strings into PostgreSQL via PgSQL--completely ignorant of
Unicode, internationalization issues--I got that strange error:

	Unable to locate type name 'u' in catalog

The simple solution in our case was just to do:

	unicodeString = foo.toxml()
	safeString = unicodeString.encode('utf-8')

And then insert the safeString--and that worked.  I confess, I know very
little about internationalization issues.

I appreciate your very timely and helpful replies.

Cheers,

// mark