lbfeng
V2EX  ›  Flask

flask + sqlalchemy + wtform 不能保存中文字符

  •  
  •   lbfeng · Jul 12, 2017 · 4826 views
    This topic created in 3418 days ago, the information mentioned may be changed or developed.
    SQLALCHEMY_DATABASE_URI = 'mysql+mysqldb://root@localhost/conferency?charset=utf8'
    
    first_name = db.Column(db.String(64))
    
    

    本地用的 sqlite 可以保存中文,但 production 的 mysql 中文变成了?。characters set 改成 utf8_generic_cli 也没用。

    4 replies  •  2017-07-12 10:48:56 +08:00
    ossicee
    ossicee
    Jul 12, 2017 via Android❤️1
    1
    创建库时确定字符集 create database db CHARSET = utf8
    hzwjz
    hzwjz
    Jul 12, 2017 via Android
    2
    default character set utf8 default collate utf8_bin.
    ToBeHacker
    ToBeHacker
    Jul 12, 2017
    3
    大一点的数据库都有字符编码设置的
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   4223 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 29ms · UTC 06:00 · PVG 14:00 · LAX 22:00 · JFK 01:00
    ♥ Do have faith in what you're doing.