Encoding issue in python using mysql connector python

Question

I have written a python script which get data from database and process it. Initially I was using pymysql for connecting database which I changed to MySQL Connector for python. When I started using MySQL Connector I am getting following issue

'ascii' codec can't encode characters in position 14-16: ordinal not in range(128)

I tried by adding charset settings of MySQL Connector but issue still persists.

Do anyone have idea on this issue?

Paste code sample please?

Aleksandar Varicak
– Aleksandar Varicak

2016-12-24 09:37:51 +00:00
Commented Dec 24, 2016 at 9:37 — Aleksandar Varicak
– Aleksandar Varicak, Commented Dec 24, 2016 at 9:37

OShadmon · Accepted Answer · 2016-12-29 03:30:02Z

2

make sure that in your table you have specified a ascii encoding

Example:

CREATE TABLE t1(
     col1 char, 
     ....,
     ....,
     ....
)Engine=InnoDB charset=ascii;

In the MySQL-Python connector specify assci encoding and enable unicode

db = MySQLdb.connect( host="localhost", port=3306, user="john", passwd="megajonhy", db="jonhydb", use_unicode=True, charset='ascii' )

I believe that by default use_unicode is set to False, and thus by setting it True you will fix the issue.

answered Dec 29, 2016 at 3:30

OShadmon

7445 silver badges11 bronze badges

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

1 Comment

lucidbrot Over a year ago

This did not help at all for my utf8mb4 database when I used use_unicode=True, charset='utf8'. What did help was this anser

Collectives™ on Stack Overflow

Encoding issue in python using mysql connector python

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related