在SQLite3中记录时的编码问题

我在Windows 7上使用Python 2.7.10编写。

#-*-coding: utf-8-*- conn = conn = connn = db.connect('main.db') #conn.text_Factory = str c = conn.cursor() c.execute('PRAGMA encoding = "UTF-8";') c.execute('''''''''''''''''''''''''''''''''''''''''''''''''''''') c.execute(''''''CREATE TABLE IF NOT EXISTS service (id INTEGER PRIMARY KEY AUTOINCREMENT, service_name TEXT, service_login TEXT, service_pwd TEXT)'') print  print u"只允许使用拉丁字母和数字" name = raw_input().strip() #name.decode('UTF-8') c.execute("SELECT COUNT(login) FROM service WHERE service_name = ?", (name,))