Hey Glenn, Thanks for your reply, I'm afraid this is where my database knowledge is stained a little, by garbage do you mean encoding? In my DB where the issue is, it's in there like so Â£60, is that classed as garbage? I didn't actually declare any character set on creation.
Table script as follows...
db = MySQLdb.connect("","", "", "")
cursor = db.cursor()
cursor.execute("DROP TABLE IF EXISTS links")
# Create table as per requirement
sql = """CREATE TABLE links (
id INT NOT NULL AUTO_INCREMENT,
cost TEXT, # column with Â£60
PRIMARY KEY (id))"""
To be a little more specific in my app I just add .decode('utf-8') within my template view (Using Flask/Jinja2) but I have also added a CSV download feature but it displays as \xc2\xa360 in that particular column (with the £ sign).
FYI I'm running .encode('utf-8') on the way in.
Any further guidance is much appreciated. :)