Hi,
I ve been trying to figure out why I can t handle utf-8 properly on my
production server, while it works perfectly on my local django dev
server
When I try to run this line
unicode_data.decode("utf-8")
With data coming from DB
" Rémi "
I get on production only
'ascii' codec can't encode character u'\xe9'
I spent a lot of time on the forums and I could fixed that rather
easily on my dev server with the addition of DEFAULT_CHARSET = 'utf-8'
in settings.py and re-defining collations and charsets in DB.
But for some reason there is still some ascii conversion in production
and it s driving me Crazy!!!
I tried it all, I don t know what to do next. Please help!
DEV ENV
------------------------------------------------------------------------------
python 2.5.1
Mysql: 6.0.3-alpha-community MySQL Community Server (GPL)
django: 0.97
os: vista
PROD ENV
------------------------------------------------------------------------------
python 2.4.4
Mysql: 5.0.32-Debian_7etch1-log Debian etch distribution
django: 0.97
os: linux
DEV DB
-------------------------------------------------------------------------------
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir C:\\Program Files\\MySQL\\MySQL Server
6.0\\share\\charsets\\
collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
On every table i did a
alter table tablename CONVERT TO CHARACTER SET utf8 collate
utf8_general_ci
PROD DB
-------------------------------------------------------------------------------
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 /usr/share/mysql/charsets/
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server utf8_unicode_ci
On every table i did a
alter table tablename CONVERT TO CHARACTER SET utf8 collate
utf8_general_ci
DEV SERVER: django dev server
-----------------------------------------------------------------------------------
no special setting
PROD SERVER : apache2
-----------------------------------------------------------------------------------
AddDefaultCharset utf8
DJANGO SETTINGS (prod and serv)
-----------------------------------------------------------------------------------
DEFAULT_CHARSET = 'utf-8'
TIME_ZONE = 'America/New York'
LANGUAGE_CODE = 'en-us'
USE_I18N = True
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
