On 15/12/2010 12:34, Romaric DEFAUX wrote:
<snip>
> To create these query, I do this :
> query = "UPDATE website SET client_name='%s' WHERE ip='%s'" %
> (self.client_name, self.ip)
> then self.cursor.execute(query)
>
Unicode can be tricky.
Don't you have to encode the string again?
I tested this in the interpreter:
a = ("UPDATE website SET client_name='%s'" % "Romariqué
Admin").decode("iso-8859-15")
print "Query %s " % a.encode("iso-8859-15")
produces UPDATE website SET client_name='Romariqué Admin'
So i would try to encode the query before issuing the self.cursor.execute(query)
Cheers,
Benedict
--
http://mail.python.org/mailman/listinfo/python-list
