django mysql utf8,如何使用utf-8设置django和mysql

I want to set my Django/mysql site to work with UTF-8. Please guide me the changes I have to make in django and mysql to make sure the following things.

User entered data in the forms will be always encoded as UTF-8

Storing the data in mysql as utf-8

Displaying utf8 encoded data in the template correctly

Also I want to know whether moving to UTF-8 encoding will remove unicode decode error like below.

UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 55: ordinal not in range(128)

Many Thanks.

解决方案

here some advices:

1) use utf8 encoding when creating database

CREATE DATABASE CHARACTER SET utf8;

2) place the following special comment in the first or second lines of your script:

# -*- coding: utf-8 -*-

3) Use unicode strings with u prefix in *.py files

unicodeString = u"hello Unicode world!"

4) Use follwing meta tag in section of your base template: