AttributeError: 'NoneType' object has no attribute 'encoding' using pymysql

Question

import pymysql

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
    passwd='123456',db='home', charset="utf-8")

cursor = conn.cursor()
cursor.execute("""create table job_list(job varchar(30) , people varchar(30) , catagory varchar(30)  , place varchar(30), publish varchar(30)) """)

try:
    cursor.execute("""INSERT  INTO  job_list(job,people,catagory,place,publish) VALUES (%s, %s, %s, %s, %s)""",
        ["算法工程师", "2018毕业生", "研发", "雅加达", "2018-03-28"])
    conn.commit()
except pymysql.Error as e:
    print(e)

cursor.close()
conn.close()

having set charset but it is not useful,how can i insert Chinese into mysql

Please add the full backtrace that Python gives you. Also, please fix the formatting of the code, it's close to unreadable. — Ulrich Eckhardt
– Ulrich Eckhardt, Commented Apr 14, 2018 at 5:55
The charset is not the python encoding specifier but one cooked up by pymysql to map to encodings. You can find the full list at https://github.com/PyMySQL/PyMySQL/blob/master/pymysql/charset.py — tdelaney
– tdelaney, Commented Apr 14, 2018 at 6:11
Its kinda lame that they don't catch the unknown charset and toss back a more sensible error message. — tdelaney
– tdelaney, Commented Apr 14, 2018 at 6:11

papaki · Accepted Answer · 2018-04-30 14:46:15Z

7

charset is a mysql database character set name that needs to be converted to a python encoding. pymysql has a large list of them in charset.py. Rather perversely, pymysql either spits back the charset name you passed in or raises the non-obvious error you see. In the pymysql world, "utf8" is a valid character set, but "utf-8" is not. So, just change your connect to

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
    passwd='123456',db='home', charset="utf8")

edited Apr 30, 2018 at 14:46

papaki

53 bronze badges

answered Apr 14, 2018 at 6:23

tdelaney

77.9k6 gold badges91 silver badges129 bronze badges

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

Collectives™ on Stack Overflow

AttributeError: 'NoneType' object has no attribute 'encoding' using pymysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related