84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
flask_sqlalchemy默认的字符集是latin-1，怎么样才能转成utf-8？
latin-1
utf-8
我试过设置SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://moling:xxx@localhost/myblog?charset=utf8'但是不起作用，请问有没小伙伴也踩过这个坑的？
SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://moling:xxx@localhost/myblog?charset=utf8'
SQLALCHEMY_DATABASE_URI = 'mysql://user:pass@localhost /db?charset=utf8'
解决，原来还要在SQL创建数据库的时候设置CREATE DATABASE myblog CHARSET=UTF8;只有这样mysql://user:pass@localhost /db?charset=utf8才能生效
CREATE DATABASE myblog CHARSET=UTF8;
mysql://user:pass@localhost /db?charset=utf8
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
SQLALCHEMY_DATABASE_URI = 'mysql://user:pass@localhost /db?charset=utf8'
解决，原来还要在SQL创建数据库的时候设置
CREATE DATABASE myblog CHARSET=UTF8;只有这样
mysql://user:pass@localhost /db?charset=utf8才能生效