在pysqlite数据库中处理中文记录

 1: >>> from pysqlite2 import dbapi2 as sqlite
 2: >>> con=sqlite.connect("e:\mytmp\mydbs.db")
 3: >>> con.text_factory=str  

 4: >>> cur=con.cursor()
 5: >>> cur.execute('select * from hello')
 6: <pysqlite2.dbapi2.Cursor object at 0x00D4EFB0>
 7: >>> d=cur.fetchall()
 8: >>> print d[1][1]
 9: 梨