[pysqlite] error: Could not decode to UTF-8

"Eric S. Johansson" <[email protected]> Fri, 23 Jan 2009 01:19:14 -0500
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
OperationalError: Could not decode to UTF-8 column 'message_originator' with
text 'Sch<F6>[email protected]'

how do I prevent injecting this kind of data and if I fail to prevent injection,
how do I handle this kind of error?  I fixed this instance by editing the record
with sqlitemanager.