Abandoned <[EMAIL PROTECTED]> writes: >> Use a different column type for cache2's column, one more appropriate >> for storing binary characters (perhaps BYTEA for Postgres). Don't >> forget to also use a bind variable, something like: >> >> cursor.execute("INSERT INTO cache2 VALUES (?)", a) >> >> Using "INSERT ... ('%s')" % (a) won't work, since the huge binary >> string in a can contain arbitrary characters, including the single >> quote. > > I tryed: > cursor.execute("INSERT INTO cache2 VALUES (?)", a)
Why are you ignoring the first sentence: "Use a different column type for cache2's column, ..."? The use of bind variables in INSERT will work only *after* you do the rest of the work. -- http://mail.python.org/mailman/listinfo/python-list