Python sqlite3.ProgrammingError：除非使用可解释8位字节串的te

['test.rus (xd0xa5xd0xb5xd0xbbxd1x8cxd1x88xd0xb8).srt',23930]
test.rus (Хельши).srt

现在,在尝试将数据插入数据库时??,我收到如下错误

Traceback (most recent call last):
  File "filedup.py",line 267,in <module>
    read_file_directory(directory)
  File "filedup.py",line 118,in read_file_directory
    (values[i][0],each,values[i][1]))
sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.

执行该操作的功能如下

from collections import defaultdict
dirDict = defaultdict(list)    
def read_file_directory(path):
    global dirDict
    logger.debug("Path being scanned %s" %path)
    fileStats = []
    for root,subFolders,files in os.walk(path):
        for file_name in files:
            fileStats = []
            fileStats.insert(0,file_name)
            fileSize = os.path.getsize(os.path.join(root,file_name))
            fileStats.insert(1,fileSize)
            dirDict[root].append(fileStats)
    #Insert the data in DB
    cursor = dbHandler.cursor()
    keys = dirDict.keys()
    for each in keys:
        values = dirDict[each]
        print values
        for i in xrange(len(values)):
            print values[i]
            print values[i][0]
            print values[i][1]
            fileName = values[i][0]
            fileSize = values[i][1]
            cursor.execute("insert or ignore into master 
                (FileName,FilePath,FileSize) values(?,?,?)",
                (values[i][0],values[i][1]))
            logger.debug("Insert data for %s,%s,%s" %(values[i][0],values[i][1]))

现在,当我试图学习Python时,我没有得到如何解决这个问题.我正在使用的Python版本如下所示

$python
Python 2.7.6 (default,Mar 22 2014,22:59:56) 
[GCC 4.8.2] on linux2

所以任何想法如何解决当前版本的Python,因为我正在寻找通用修复程序,以便它甚至可以在更高版本上工作.
此外,我观察到由于此错误,没有数据被插入数据库.那么如何确保即使某些操作导致错误,也可以将先前的数据插入到数据库中.