sqlalchemy utf8 quickstart

Posted by zyanlu on 2012/01/25 Leave a comment (0) Go to comments

先把mysql全都配成utf8,比较坑爹的是table charset貌似没法指定默认utf-8,必须create的时候指定

[client]
default-character-set=utf8
[mysqld]
collation-server = utf8_general_ci
character-set-server = utf8

验证一下:

SHOW VARIABLES LIKE ‘character_set_%’;
SHOW VARIABLES LIKE ‘collation_%’;

# -*- coding: utf-8 -*-
import sqlalchemy
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, BigInteger,String,Text
from sqlalchemy.orm import sessionmaker

Base = declarative_base()
class Node(Base):
    __tablename__ = 'node'
    __table_args__ = {'mysql_engine':'InnoDB','mysql_charset':'utf8'}
    id = Column(Integer, primary_key=True)
    path = Column(String(255), index=True)
    name = Column(String(255))
    data = Column(Text)
    datatype = Column(String(255))

if __name__ == '__main__':
    engine = sqlalchemy.create_engine('mysql+mysqldb://root:123456@127.0.0.1:3306/dbname?charset=utf8', echo=True)

    Base.metadata.drop_all(engine)
    Base.metadata.create_all(engine) 

    Session = sessionmaker()
    Session.configure(bind=engine)
    session = Session()
    session.commit()

    n = Node()
    n.path = "/"
    n.name = "汉字"

    session.add(n)
    session.commit()

__table_args__指定了表编码，这样就可以很好支持中文了⋯ 如果有能在mysql配置里指定编码的方法请留言⋯