设置Django / MySQL站点使用UTF-8 [英] Setting Django/MySQL site to use UTF-8

问题描述

我想设置我的Django站点以一种万无一失的方式使用UTF-8 for MySQL，无论MySQL安装是否使用UTF-8作为默认值。除了使用UTF-8编码创建表之外，我还将以下内容添加到settings.py中的数据库初始化中，以确保连接也使用utf-8：

I want to set my Django site to use UTF-8 for MySQL in a foolproof way, regardless of whether the MySQL installation uses UTF-8 as its default. In addition to creating the tables with UTF-8 encoding, I added the following to my database initialization in settings.py to ensure the connection is also using utf-8:

'OPTIONS': { 'init_command': 'SET storage_engine=INNODB; SET names "utf8"' }

这会导致错误：

_mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now")

正确的方法是什么？还有另一个需要执行SET NAMES的地方吗？

What is the right way to do this? Is there another place where the SET NAMES needs to be executed?

推荐答案

您只需要使用SET一次，并附加其他命令：

You need only using SET once only and appending others commands as:

'SET storage_engine=INNODB,character_set_connection=utf8,collation_connection=utf8_unicode_ci'

如 here

这篇关于设置Django / MySQL站点使用UTF-8的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！