python sqlalchemy中文

oracle   

import os

os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'

mysql

self.engine=create_engine("mysql://root:pass@localhost/test",connect_args={'charset':'utf8'},echo=True) workaround 1, take effect 参见“cparams.update(kwargs.pop('connect_args', {}))”

self.engine=create_engine("mysql://root:pass@localhost/test?charset=utf8",echo=True) #workaround 2, take effect 参见“ opts.update(url.query)”