现象:
错误代码:
username = self.db_config['username']
password = self.db_config['password']
host = self.db_config['host']
port = int(self.db_config['port']) # 类型转换为整型
database = self.db_config['database']
charset = self.db_config['charset']
self._conn = MySQLdb.connect(host, username, password, database, port, charset)
self._log.info('成功连接数据库')
以上所有的参数均放在配置文件里
修改之后的代码:
username = self.db_config['username']
password = self.db_config['password']
host = self.db_config['host']
port = int(self.db_config['port']) # 类型转换为整型
database = self.db_config['database']
self._conn = MySQLdb.connect(host, username, password, database, port, charset='utf8')
self._log.info('成功连接数据库')
补充 charset要单独写,放入配置里读取,还是乱码,不知道是不是操作还是其他原因,目前是这样解决的,如果有不对的地方,希望读到这篇文章的童鞋可以给出意见,谢谢
修改完之后的现象: