Fix UnicodeDecodeError

I have the following code . I use Python 2.7

import csv
import sqlite3

conn = sqlite3.connect('torrents.db')
c = conn.cursor()

# Create table
c.execute('''DROP TABLE torrents''')
c.execute('''CREATE TABLE IF NOT EXISTS torrents
             (name text, size long, info_hash text, downloads_count long, 
             category_id text, seeders long, leechers long)''')

with open('torrents_mini.csv', 'rb') as csvfile:
    spamreader = csv.reader(csvfile, delimiter='|')
    for row in spamreader:
        name = unicode(row[0])
        size = row[1]
        info_hash = unicode(row[2])
        downloads_count = row[3]
        category_id = unicode(row[4])
        seeders = row[5]
        leechers = row[6]
        c.execute('INSERT INTO torrents (name, size, info_hash, downloads_count, 
                   category_id, seeders, leechers) VALUES (?,?,?,?,?,?,?)',
                   (name, size, info_hash, downloads_count, category_id, seeders, leechers))

conn.commit()
conn.close()

The error message I receive is

Traceback (most recent call last):
  File "db.py", line 15, in <module>
    name = unicode(row[0])
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 14: ordinal not in range(128)

If I don't convert into unicode then the error i get is

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.