Encoding problem when writing to sqlite3

Writing in Windows 7 on python 2.7.10.

#-*-coding: utf-8 -*-conn = db.connect('main.db')#conn.text_factory = strc = conn.cursor()c.execute('PRAGMA encoding=""UTF-8"";')c.execute('''CREATE TABLE IF NOT EXISTS user (login text, password text) ''')c.execute('''CREATE TABLE IF NOT EXISTS service (useame text, service_name text, service_login text, service_pwd text)''')print u""Welcome to the password manager""print u""Only Latin letters and numbers are allowed""name = raw_input(u""Introduce yourself: ""