+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: UnicodeDecodeError: 'utf-8' codec can't decode byte 0x92 error from Mysql call (/thread-33463.html)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x92 error from Mysql call - AkaAndrew123 - Apr-27-2021
Python3, Ubuntu 20.04
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x92
When querying the MySQL database I receive this error, the code was working under Python2.7 but not in Python3.
appointments = App_Connection().Query_All("SELECT * FROM `ea_appointments` WHERE `id` > '%s'" % (record_num,)) class App_Connection(object):
def __init__(self, host="xx.xxx.x.xxx", user="_app", passwd="", db="appoint"):
self.host = host
self.user = user
self.passwd = passwd
self.dbc = db
self.connection()
def connection(self):
self.connection = MySQLdb.connect(self.host, self.user, self.passwd, self.dbc)
def Query_All(self, sql_statement):
cursor = self.connection.cursor()
cursor.execute(sql_statement)
result = cursor.fetchall()
cursor.close()
return result
def Query_One(self, sql_statement):
cursor = self.connection.cursor()
cursor.execute(sql_statement)
result = cursor.fetchone()
cursor.close()
return result
def Commit(self, sql_statement):
cursor = self.connection.cursor()
cursor.execute(sql_statement)
self.connection.commit()
cursor.close()
RE: UnicodeDecodeError: 'utf-8' codec can't decode byte 0x92 error from Mysql call - AkaAndrew123 - Apr-28-2021
This must be a MySQLdb thing as I have changed module to
import pymysqland it works as expected