Codierungsproblem beim Speichern in SQLite3

Ich schreibe unter Windows 7 in Python 2.7.10.

  #-*-coding: utf-8-*- conn = sqlite3.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 (service_id INTEGER PRIMARY KEY AUTOINCREMENT, service_name TEXT, service_login TEXT, service_pwd TEXT)'''''') print("Welcome to the password manager") print(u"Nur lateinische Buchstaben sind erlaubt")