初始化DB时出错

[linkerlin]

Python 2.7 @macosx
数据库是MySQL 5.1
执行到Syncdb是出错信息如下：
Creating table blog_post
Creating table blog_link
Creating table django_admin_log

You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): yes
Username (leave blank to use 'linkerlin'):
E-mail address: linker.lin@qq.com
Password:
Password (again):
Superuser created successfully.
Traceback (most recent call last):
File "manage.py", line 14, in
execute_manager(settings)
File "/Library/Python/2.7/site-packages/django/core/management/init.py", line 459, in execute_manager
utility.execute()
File "/Library/Python/2.7/site-packages/django/core/management/init.py", line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
self.execute(_args, *_options.dict)
File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 232, in execute
output = self.handle(_args, *_options)
File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 371, in handle
return self.handle_noargs(**options)
File "/Library/Python/2.7/site-packages/django/core/management/commands/syncdb.py", line 110, in handle_noargs
emit_post_sync_signal(created_models, verbosity, interactive, db)
File "/Library/Python/2.7/site-packages/django/core/management/sql.py", line 189, in emit_post_sync_signal
interactive=interactive, db=db)
File "/Library/Python/2.7/site-packages/django/dispatch/dispatcher.py", line 172, in send
response = receiver(signal=self, sender=sender, **named)
File "/Library/Python/2.7/site-packages/django/contrib/auth/management/init.py", line 35, in create_permissions
ctype = ContentType.objects.get_for_model(klass)
File "/Library/Python/2.7/site-packages/django/contrib/contenttypes/models.py", line 42, in get_for_model
defaults = {'name': smart_unicode(opts.verbose_name_raw)},
File "/Library/Python/2.7/site-packages/django/db/models/manager.py", line 134, in get_or_create
return self.get_query_set().get_or_create(**kwargs)
File "/Library/Python/2.7/site-packages/django/db/models/query.py", line 452, in get_or_create
obj.save(force_insert=True, using=self.db)
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line 463, in save
self.save_base(using=using, force_insert=force_insert, force_update=force_update)
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line 551, in save_base
result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
File "/Library/Python/2.7/site-packages/django/db/models/manager.py", line 203, in _insert
return insert_query(self.model, objs, fields, **kwargs)
File "/Library/Python/2.7/site-packages/django/db/models/query.py", line 1593, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "/Library/Python/2.7/site-packages/django/db/models/sql/compiler.py", line 912, in execute_sql
cursor.execute(sql, params)
File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 114, in execute
return self.cursor.execute(query, args)
File "/Library/Python/2.7/site-packages/MySQLdb/cursors.py", line 201, in execute
self.errorhandler(self, exc, value)
File "/Library/Python/2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.DatabaseError: (1366, "Incorrect string value: '\xE6\xA0\x87\xE7\xAD\xBE' for column 'name' at row 1")

求助！

[ichuan]

应该是 mysql 编码问题，具体解决办法可以参考： http://ichuan.net/post/17/#comment-354605824

2012/12/14 Linker Lin notifications@github.com

Python 2.7 @macosx https://github.com/MacOSX
数据库是MySQL 5.1
执行到Syncdb是出错信息如下：
Creating table blog_post
Creating table blog_link
Creating table django_admin_log

You just installed Django's auth system, which means you don't have any
superusers defined.
Would you like to create one now? (yes/no): yes
Username (leave blank to use 'linkerlin'):
E-mail address: linker.lin@qq.com
Password:
Password (again):
Superuser created successfully.
Traceback (most recent call last):
File "manage.py", line 14, in
execute_manager(settings)
File
"/Library/Python/2.7/site-packages/django/core/management/init.py",
line 459, in execute_manager
utility.execute()
File
"/Library/Python/2.7/site-packages/django/core/management/init.py",
line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Library/Python/2.7/site-packages/django/core/management/base.py",
line 196, in run_from_argv
self.execute(_args, *options.dict)
File "/Library/Python/2.7/site-packages/django/core/management/base.py",
line 232, in execute
output = self.handle(_args, *_options)
File "/Library/Python/2.7/site-packages/django/core/management/base.py",
line 371, in handle
return self.handle_noargs(_options)
File
"/Library/Python/2.7/site-packages/django/core/management/commands/syncdb.py",
line 110, in handle_noargs
emit_post_sync_signal(created_models, verbosity, interactive, db)
File "/Library/Python/2.7/site-packages/django/core/management/sql.py",
line 189, in emit_post_sync_signal
interactive=interactive, db=db)
File "/Library/Python/2.7/site-packages/django/dispatch/dispatcher.py",
line 172, in send
response = receiver(signal=self, sender=sender, _named)
File
"/Library/Python/2.7/site-packages/django/contrib/auth/management/init.py",
line 35, in create_permissions
ctype = ContentType.objects.get_for_model(klass)
File
"/Library/Python/2.7/site-packages/django/contrib/contenttypes/models.py",
line 42, in get_for_model
defaults = {'name': smart_unicode(opts.verbose_name_raw)},
File "/Library/Python/2.7/site-packages/django/db/models/manager.py", line
134, in get_or_create
return self.get_query_set().get_or_create(_kwargs)
File "/Library/Python/2.7/site-packages/django/db/models/query.py", line
452, in get_or_create
obj.save(force_insert=True, using=self.db)
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line
463, in save
self.save_base(using=using, force_insert=force_insert,
force_update=force_update)
File "/Library/Python/2.7/site-packages/django/db/models/base.py", line
551, in save_base
result = manager._insert([self], fields=fields, return_id=update_pk,
using=using, raw=raw)
File "/Library/Python/2.7/site-packages/django/db/models/manager.py", line
203, in _insert
return insert_query(self.model, objs, fields, **kwargs)
File "/Library/Python/2.7/site-packages/django/db/models/query.py", line
1593, in insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "/Library/Python/2.7/site-packages/django/db/models/sql/compiler.py",
line 912, in execute_sql
cursor.execute(sql, params)
File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py",
line 114, in execute
return self.cursor.execute(query, args)
File "/Library/Python/2.7/site-packages/MySQLdb/cursors.py", line 201, in
execute
self.errorhandler(self, exc, value)
File "/Library/Python/2.7/site-packages/MySQLdb/connections.py", line 36,
in defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.DatabaseError: (1366, "Incorrect string value:
'\xE6\xA0\x87\xE7\xAD\xBE' for column 'name' at row 1")

求助！

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/5.

yc