On Wed, Aug 12, 2009 at 6:51 PM, <exarkun@twistedmatrix.com> wrote:
On 03:28 pm, petshmidt@googlemail.com wrote:
Hello,
does pyPgSQL doesn't support unicode?
execute(query, params) #all items in params list are of <type 'unicode'>
I'm getting 'ascii' codec can't encode character u'\xfc' in position 1: ordinal not in range(128)
Do I need encode my params before sending a query and then decode all results back to unicode?
I don't know about pyPgSQL's unicode support.
I did recently learn that pyPgSQL doesn't support bind parameters, apparently resulting in almost any use of it insecure and vulnerable to SQL injection attacks. You may want to investigate this further before deciding if it's worth figuring out how unicode works.
That's interesting. May be I should try psycorg2. By the way, pyPgSQL has no problem with unicode, the problem was elsewhere
Jean-Paul
_______________________________________________ Twisted-Python mailing list Twisted-Python@twistedmatrix.com http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python