| Код |
#-*-coding:utf8 -*-
import MySQLdb
con = MySQLdb.connect (host = "localhost",user = "root",db = "test",charset='utf8',use_unicode=True)
cur = con.cursor()
cur.execute("SET NAMES 'utf8'")
print con.character_set_name()
#cur.execute("create table base (val char(50))")
cur.execute("insert into base values 'аыв'".decode('utf8'))
#cur.execute('select * from base')
#result = cur.fetchall()
#print result
cur.close()
con.commit()
con.close()
|
Error:
| Код |
latin1
Traceback (most recent call last):
File "test.py", line 8, in <module>
cur.execute("insert into base values 'п╟я▀п╡'".decode('utf8'))
File "/usr/local/lib/python2.5/site-packages/MySQLdb/cursors.py", line 146, in execute
query = query.encode(charset)
UnicodeEncodeError: 'latin-1' codec can't encode characters in position 25-27: ordinal not in range(256)
|
|
)
