问题描述：关于django1.0+python2.5+mysql4.1的中文编码问题

在我编写Model代码时遇到这样的问题：

开始我的mysql安装时默认的字符编码是utf-8

接着我创建数据库mysite

这是数据库的状态信息

这是我的工程文件夹，此时已经创建了一个app叫blog

为了方便起见只写了一个类

以下是settings.py:

# Django settings for
mysite project.

DEBUG = True

TEMPLATE_DEBUG = DEBUG

ADMINS = (

# ('Your Name',
'your_email@domain.com'),

)

MANAGERS = ADMINS

DATABASE_ENGINE =
'mysql' # 'postgresql_psycopg2', 'postgresql', 'mysql',
'sqlite3' or 'oracle'.

DATABASE_NAME =
'mysite' # Or path to database file if using sqlite3.

DATABASE_USER = 'root'
# Not used with sqlite3.

DATABASE_PASSWORD =
'123' # Not used with sqlite3.

DATABASE_HOST =
'localhost' # Set to empty string for localhost. Not used
with sqlite3.

DATABASE_PORT = ''
# Set to empty string for default. Not used with sqlite3.

# Local time zone for
this installation. Choices can be found here:

#
http://en.wikipedia.org/wiki/List_of_tz_zones_by_name

# although not all
choices may be available on all operating systems.

# If running in a
Windows environment this must be set to the same as your

# system time zone.

TIME_ZONE =
'America/Chicago'

# Language code for
this installation. All choices can be found here:

#
http://www.i18nguy.com/unicode/language-identifiers.html

LANGUAGE_CODE = 'en-us'

SITE_ID = 1

# If you set this to
False, Django will make some optimizations so as not

# to load the
internationalization machinery.

USE_I18N = True

# Absolute path to the
directory that holds media.

# Example:
"/home/media/media.lawrence.com/"

MEDIA_ROOT = ''

# URL that handles the
media served from MEDIA_ROOT. Make sure to use a

# trailing slash if
there is a path component (optional in other cases).

# Examples:
"http://media.lawrence.com", "http://example.com/media/"

MEDIA_URL = ''

# URL prefix for admin
media -- CSS, JavaScript and images. Make sure to use a

# trailing slash.

# Examples:
"http://foo.com/media/", "/media/".

ADMIN_MEDIA_PREFIX =
'/media/'

# Make this unique, and
don't share it with anybody.

SECRET_KEY =
'6lkd7f-o@kecgk5$#if)$8n03u!5@p4rsz*_k+b37m^+b$=4v%'

# List of callables
that know how to import templates from various sources.

TEMPLATE_LOADERS = (

'django.template.loaders.filesystem.load_template_source',

'django.template.loaders.app_directories.load_template_source',

#
'django.template.loaders.eggs.load_template_source',

)

MIDDLEWARE_CLASSES = (

'django.middleware.common.CommonMiddleware',

'django.contrib.sessions.middleware.SessionMiddleware',

'django.contrib.auth.middleware.AuthenticationMiddleware',

)

ROOT_URLCONF =
'mysite.urls'

TEMPLATE_DIRS = (

# Put strings here,
like "/home/html/django_templates" or
"C:/www/django/templates".

# Always use
forward slashes, even on Windows.

# Don't forget to
use absolute paths, not relative paths.

)

INSTALLED_APPS = (

#'django.contrib.auth',

#'django.contrib.contenttypes',

#'django.contrib.sessions',

#'django.contrib.sites',

'mysite.blog'

)

DEFAULT_CHARSET= 'utf8'

利用manage.py
sync同步数据库

再写入数据库就出现这样的出错信息：

再后来的时候我发现在数据库下直接利用insert
into 插入时也是有问题的：

显示插入成功，但利用select
*却显示不出来

当我把mysql的编码变成GB2312时，这样的问题就可以解决了：

但是利用shell却还是提示一样的错误：

按照网上的方法我全试过，噢，对了我的py文件也是按照utf8编码保存的，到底是怎么回事？这件编码的问题困扰了我好几天了，希望可以帮助我解决