python用法:处理sqlite中的中文字符时遇到的问题
作为初学才，学起python，是挺快，但是也不免常常出些小错。在访问sqlite3的时候，我写了下边的测试代码。文件test.py是utf-8编码的，OK，结果没问题。
<div style="padding-right: 5.4pt; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 4px; width: 95%; padding-top: 4px;">http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif#!/usr/bin/envpython
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif#coding=utf-8
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifimportsqlite3
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif#con=sqlite3.connect(r"sqlite.db")
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifcon=sqlite3.connect(r"e: estsqlite3.db")
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif#con.text_factory=str
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifcur=con.cursor()
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif#cur.execute("insertintobasvslvoy(vslcode,voyage,vslename)values(?,?,?)",(u'tt',u'tt',u'tt'))
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifcur.execute("insertintot1values(?,?)",(10,u'中文测试gbk10'))
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifcon.commit()
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifcur.execute(u"select*fromt1wherecol2like'中%'")
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifforrowincur.fetchall():
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifprintrow,row[1].encode('gbk')
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifcon.close()
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
页:
[1]