Problema de codificación al grabar en SQLite3

Escribo en Windows 7 con Python 2.7.10.

  #-*-coding: utf-8-*- conn = 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 (service_name TEXT, service_login TEXT, service_pwd TEXT) '' )  print   "Welcome to the password manager"   print   u"Solo se permiten letras del alfabeto latino y números"  name = raw_input ( "Nombre: " ). strip () #name.decode('utf-8')  c.execute ( "SELECT COUNT(login) "