On 27/11/2007, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
>
>    IWBN if you run the tests using MySQLdb directly, or at least patch
> SQLObject to not set "need_unicode" in MySQLConnection.

import MySQLdb

x = MySQLdb.connect(db='test', user='markus', charset='utf8') #
supplying charset implies use_unicode=True
c = x.cursor()

c.execute('DROP TABLE person')
c.execute('CREATE TABLE person(id int, name varchar(20))')
c.execute('INSERT INTO person (id, name) VALUES (%s, %s)', (0, '\x61'))
c.execute('SELECT * FROM person')

value = c.fetchone()[-1]
assert value == '\x61' # ok
print value # -> a

c.close()
x.commit()
x.close()

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to