Re: django storage chinese failed to mysql!!

I have checked mysql database, maybe have no issue, but still show the same error.detail as below:

 

mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+----------------------------------------------------
-----+
| Variable_name            | Value
     |
+--------------------------+----------------------------------------------------
-----+
| character_set_client     | utf8
     |
| character_set_connection | utf8
     |
| character_set_database   | utf8
     |
| character_set_filesystem | binary
     |
| character_set_results    | utf8
     |
| character_set_server     | utf8
     |
| character_set_system     | utf8
     |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.1\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+

2010/7/28 Dennis Kaarsemaker <dennis@kaarsemaker.net>

On wo, 2010-07-28 at 09:11 +0800, pengbo xue wrote:
> hi all,
>
> I can register from my django web page in english,but it can't storage
> chinese to django mysql database.
>
> please give me advice.  thx

Check your table definition to see whether the field you try to store is
a latin1 or utf8 field. If it is latin1, it will not support chinese
characters.

--
Dennis K.

They've gone to plaid!

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

--

cowboy

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.