#!/usr/bin/python
# -*- coding: utf-8 -*-
 
import MySQLdb
def main():
    fullname = "趙錢(qián)孫李"
 
    conn = MySQLdb.connect(host='localhost', user='root',passwd='123', db='account', charset='utf8')  # OK
    #conn = MySQLdb.connect(host='localhost', user='root',passwd='123', db='account')  # Error!!!
    cursor = conn.cursor()
    cursor.execute("insert into account (username,password) values ('%s','%s')" % (fullname, "111"))
    conn.commit()
    cursor.close()
    conn.close()
 
if __name__ == "__main__":
    main()

import sys
reload(sys)
sys.setdefaultencoding('utf-8')

print sys.getdefaultencoding()

?# -*- coding: utf-8 -*-
?import ?sys,MySQLdb
conn = MySQLdb.connect(host = " 127.0.0.1 " ,user = " webdb " ,passwd = " web123 " ,db = " web " ,charset = " utf8 " ) ? ? # 需要設(shè)定一下charset為utf-8
?cursor = conn.cursor() ? ? # 生成連接的指針對(duì)象
?# 進(jìn)行字符串編碼轉(zhuǎn)換并進(jìn)行插入
?a ?= ? " 浦發(fā)銀行 "
a ?= ?a.decode( " gbk " ).encode( " utf-8 " ) ? ? # 編碼轉(zhuǎn)換為utf-8
?sql = " insert into stocklist (stockno,stockname) values (%s,%s) " ? ? ?# 生成sql語(yǔ)句
?param = ( ' 600000 ' ,a) ? ? # 生成sql語(yǔ)句的參數(shù)
?n ?= ?cursor.execute(sql,param) ? ? # 執(zhí)行sql語(yǔ)句
# 以上操作等價(jià)于n = cursor.execute("insert into stocklist (stockno,stockname) values ('430004','"+ "浦發(fā)銀行".decode("gbk").encode("utf-8") + "')")
?print ?n
conn.commit() ?# 提交操作結(jié)果
?# 進(jìn)行查詢(xún)操作檢查剛剛執(zhí)行的插入操作結(jié)果
?n ?= ?cursor.execute( " select * from stocklist " )
?for ?row ?in ?cursor.fetchall():
? ? ?print ?row[0] ?+ ?row[ 1 ]
cursor.close() ? ? # 關(guān)閉指針
?conn.close() ? ? # 關(guān)閉連接