Diez B. Roggisch wrote: > "Select * from table where name like '%s%%'" % > "José".decode("latin-1").encode("utf-8") Make it easy on yourself and encode the whole statement: conn.execute(query.encode('utf8')) Robert Brewer System Architect Amor Ministries fumanchu at amor.org