python3 pymysql 'latin-1' codec can't encode character 错误 问题解决
来源:互联网 发布:dos复制文件到linux 编辑:程序博客网 时间:2024/05/24 11:13
完整代码:
#coding: utf-8
import pymysql
# 打开数据库连接
db = pymysql.connect("localhost","root","00000000","TESTDB" ,use_unicode=True, charset="utf8")
# 若没有 use_unicode=True, charset="utf8" 那么就会发生如题错误:
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# SQL 插入语句
sql = """INSERT INTO EMPLOYEE(FIRST_NAME,
LAST_NAME, AGE, SEX, INCOME)
VALUES ('测', '试', 20, '男', 99999)"""
#db.set_character_set('utf8')
cursor.execute('SET NAMES utf8;')
cursor.execute('SET CHARACTER SET utf8;')
cursor.execute('SET character_set_connection=utf8;')
try:
# 执行sql语句
cursor.execute(sql)
# 提交到数据库执行
db.commit()
print(" 没有错误 请党和组织人民放心! ")
except Exception as e:
print(e)
# 如果发生错误则回滚
print(" 发生错误")
db.rollback()
# 关闭数据库连接
db.close()
执行结果如下:
问题原因:
解决思路:
设置连接和游标的charset为你所希望的编码,如utf8
参考网站:
http://stackoverflow.com/questions/3942888/unicodeencodeerror-latin-1-codec-cant-encode-character
- python3 pymysql 'latin-1' codec can't encode character 错误 问题解决
- python3 pymysql 'latin-1' codec can't encode character 错误 问题解决
- python3错误——UnicodeEncodeError: 'latin-1' codec can't encode character...
- python mysql数据库 'latin-1' codec can't encode character错误问题解决
- python mysql数据库 'latin-1' codec can't encode character错误问题解决
- python mysql数据库 'latin-1' codec can't encode character错误问题解决
- python mysql数据库 'latin-1' codec can't encode character错误问题解决
- 'latin-1' codec can't encode character 的解决方案
- UnicodeEncodeError: 'latin-1' codec can't encode character
- UnicodeEncodeError: 'latin-1' codec can't encode character 报错
- 解决UnicodeEncodeError: 'latin-1' codec can't encode character
- UnicodeEncodeError: 'latin-1' codec can't encode character
- python mysql 'latin-1' codec can't encode character
- Python : UnicodeEncodeError: 'latin-1' codec can't encode character
- python写入mysql时候 出现'latin-1' codec can't encode character 问题解决方法 以及python设置utf-8
- python连接mysql 报'latin-1' codec can't encode character解决方法
- python mysqldb 数据库插入中文 “"UnicodeEncodeError:'latin-1' codec can't encode character ..."”
- python mysqldb 数据库插入中文 “"UnicodeEncodeError:'latin-1' codec can't encode character ..."”
- linux后台运行任务——screen
- 树莓派3B安装QT5
- coderforces 670D2 Magic Powder - 2
- 进程通信之文件映射对象
- java web-1:走进java web
- python3 pymysql 'latin-1' codec can't encode character 错误 问题解决
- 1090. Highest Price in Supply Chain (25)
- 【NBUTOJ】Red packet
- Leetcode 377. Combination Sum IV
- POJ-3258 River Hopscotch
- input标签file 多文件上传
- Pie<poj3122>
- Google hacker工具使用和Google hacker防范
- Spring4学习笔记----Spring的依赖注入详解