On Mar 11, 2006, at 4:52 AM, [EMAIL PROTECTED] wrote:

>
> in trying to unravel my previous post:
>
> http://groups.google.com/group/django-users/browse_thread/thread/ 
> b21804c6f176a61c
>
..
> what character set and collation does django expect when setting up  
> the
> admin site?

When connecting to MySQL you need to specify which encoding you are  
going to use to get results and send data.
Right now, Django's MySQL backend sets this to UTF8 when the server  
is MySQL 4.1 or higher. There are talks/posts which discuss to make  
this configurable. I think we need this ASAP.

Anyway, check what character set your MySQL server is using right now:
   mysql> SHOW VARIABLES LIKE 'char%';

In the client you need to do before you do anything else:
   mysql> SET NAMES 'latin1'; -- or whatever encoding you need, SHOW  
CHARACTER SET;

In Django, in 0.91 this is done in django/core/db/backends/mysql.py.  
You will need change it there right now, or introduce  
DATABASE_ENCODING in your settings.py and use that..

Hope this helps.

Regards,

Geert

--
Geert Vanderkelen
http://Kemuri.Org






--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

Reply via email to