Re: django storage chinese failed to mysql!!

2010-07-28 Thread Dennis Kaarsemaker
Those settings are not all. You need to check the table definition with
either describe or show create table.

On wo, 2010-07-28 at 19:40 +0800, pengbo xue wrote:
> 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 
> 
> 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-us...@googlegroups.com.
> To unsubscribe from this group, send email to django-users
> +unsubscr...@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-us...@googlegroups.com.
> To unsubscribe from this group, send email to django-users
> +unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.

-- 
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-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.



Re: django storage chinese failed to mysql!!

2010-07-28 Thread pengbo xue
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 

>  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-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@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-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.



Re: django storage chinese failed to mysql!!

2010-07-27 Thread Dennis Kaarsemaker
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-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.



django storage chinese failed to mysql!!

2010-07-27 Thread pengbo xue
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
-- 

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-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.