Re: Passing and returning Unicode objects

Il sab, 2004-03-06 alle 08:40, Lutz Steinborn ha scritto:
> Hi Adrian,
> 
> I'am using it in this way:
> 
> ins = '''INSERT INTO tester VALUES ('%s')'''
> cursor.execute(ins % u"hi Adrian")

using % is _very_ wrong. psycopg supports bound variables that free you
from doing the quoting:

ins = '''INSERT INTO tester VALUES ('%s')'''
curs.execute(ins, (u"hi Adrian".encode('utf-8'),))

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                
fog-8fiUuRrzOP0dnm+yROfE0A@xxxxxxxxxxxxxxxx
INIT.D Developer                                           
fog-NGVKUo/i/6DYtjvyW6yDsg@xxxxxxxxxxxxxxxx
  We should forget about small efficiencies, say about 97% of the
   time: premature optimization is the root of all evil.    -- D.E.Knuth

signature.asc
Description: Questa parte del messaggio =?ISO-8859-1?Q?=E8?= firmata

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg