I have a python program wherein I access a url and extract data. I then input this data into a mysql table. The mysql table has columns `pid ,position,club, points,s,availability, rating,name` . I have no issues with the python program ( I hope) but the database apparently does not seem to accept names with UTF alphabets `ex: Jääskeläinen` . How do I make the database to accept these names? I tried using the answer given [here](https://stackoverflow.com/questions/5420787/mysql-and-php-encodings). But the program still gives me the following error: 

```
Traceback (most recent call last):
  File "C:\Users\GAMER\Desktop\Padai\Fall 13\ADB\player_extract.py", line 49, in <module>
    sql += "('{0}', '{1}', '{2}', '{3}', '{4}','{5}','{6}','{7}')".format(count,position,club, points,s,availability, rating,name)
UnicodeEncodeError: 'ascii' codec can't encode characters in position 1-2: ordinal not in range(128)
excepted Goalkeepers Jääskeläinen West Ham 67 £5.5

```

My python code is this"

```
# -*- coding: utf-8 -*-
from bs4 import BeautifulSoup
from urllib import urlopen
from pprint import pprint
import MySQLdb
import traceback
import re
#fetch players list from site

url = "http://fantasy.premierleague.com/player-list/"
html = urlopen(url).read()

soup = BeautifulSoup(html)
h2s = soup.select("h2")
tables = soup.select("table")

first = True
title =""
players = []
for i,table in enumerate(tables):
    if first:
         title =  h2s[int(i/2)].text
    for tr in table.select("tr"):
        player = (title,)
        for td in tr.select("td"):
            player = player + (td.text,)
        if len(player) > 1:
            players.append(player)

    first = not first

##SQL connectivity and data entry

db = MySQLdb.connect(host="localhost", user="root", passwd="hassan28", db = "adbpro")

cur = db.cursor()

try:
    count = 1
    for i in players:
        position, name, club, points, price = i
        s = price[1:]
        name = name.replace("'"," ")
        rating = 4
        availability = 1
        sql = "INSERT INTO players (pid,position,club,points,price,availability,rating,name) VALUES "
        try:
            sql += "('{0}', '{1}', '{2}', '{3}', '{4}','{5}','{6}','{7}')".format(count,position,club, points,s,availability, rating,name)
            cur.execute(sql)
            count +=1
        except UnicodeError:
            traceback.print_exc()
            print "excepted", position, name, club, points, price
            continue
        #print sql

    db.commit()

except:
    print sql
    traceback.print_exc()
    db.rollback()
    cur.execute("SELECT * FROM PLAYERS")

print "done"

```

Any help will be greatly appreciated.