MySQLdb / Python: Can't insert certain characters in the db

Question

#!/usr/bin/env python
# -*- coding: utf-8 -*- 

import MySQLdb

conn = MySQLdb.connect('localhost', 'django_user', 'haha123', 'mydb')
cur = conn.cursor()

f = open('/home/kave/projects/cb/database/country_code_drupal_nov_2011.txt')

cur.execute("INSERT INTO myapp_app_currency (currency) VALUES ('USD - $'),('EUR - €'), ('GBP - £'), ('CAD - $'), ('AUD - $'), ('BRL - R$');")

For some reason I can insert this data successfully into my database, however two entries get corrupted.

EUR - € becomes EUR - â‚¬
GBP - £ becomes GBP - Â£

I thought I had set it as utf8 and it should roll, why there a problem only with those two characters?

Incidentally, you should probably split the symbol and the description into separate columns. — mluebke
– mluebke, Commented Nov 10, 2012 at 0:01

Maehler · Accepted Answer · 2012-11-09 21:53:52Z

3

Try setting the charset when connecting to the database:

conn = MySQLdb.connect('host', 'usr', 'pass', 'db', charset='utf8')

When you use # -*- coding: utf-8 -*- in the document, it only applies to the source code document, not to what it performs.

edited Nov 9, 2012 at 21:53

answered Nov 9, 2012 at 21:47

Maehler

6,4111 gold badge44 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Houman Over a year ago

that worked. Thanks. Could you elaborate what you mean by actual source?

Maehler Over a year ago

I mean that it specifies the encoding of the source code document. See PEP 0263 for more info.

Collectives™ on Stack Overflow

MySQLdb / Python: Can't insert certain characters in the db

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related