id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
8340	MySQL case sensitivity and utf8_bin / 2710	hrauch	Malcolm Tredinnick	"As noted in the documentation, I tried to change the collation within my Django-database. 

So I dumped the database and changed ""utf8_german_ci"" to ""utf8_bin"". After restoring the data and trying to open one page, I'll get the following error (I'm using the latest svn-version 8366):

{{{
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] mod_python (pid=2259, interpreter='dms', phase='PythonHandler?', handler='django.core.handlers.modpython'): Application error 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] ServerName?: 'www.dms.bildung.hessen.de' 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] DocumentRoot?: '/srv/www/htdocs' 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] URI: '/news/index.html' 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] Location: None 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] Directory: None [Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] Filename: '/srv/www/htdocs/news' 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] PathInfo?: '/index.html' 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] Traceback (most recent call last):

[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/lib64/python2.5/site-packages/mod_python/importer.py"", line 1537, in HandlerDispatch?\n default=default_handler, arg=req, silent=hlist.silent) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/lib64/python2.5/site-packages/mod_python/importer.py"", line 1229, in _process_target\n result = _execute_target(config, req, object, arg) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/lib64/python2.5/site-packages/mod_python/importer.py"", line 1128, in _execute_target\n result = object(arg) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/core/handlers/modpython.py"", line 210, in handler\n return ModPythonHandler?()(req) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/core/handlers/modpython.py"", line 183, in call\n response = self.get_response(request) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/core/handlers/base.py"", line 67, in get_response\n response = middleware_method(request) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/middleware/locale.py"", line 16, in process_request\n language = translation.get_language_from_request(request) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/utils/translation/init.py"", line 97, in get_language_from_request\n return real_get_language_from_request(request) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/utils/translation/trans_real.py"", line 351, in get_language_from_request\n lang_code = request.session.get('django_language', None) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/contrib/sessions/backends/base.py"", line 50, in get\n return self._session.get(key, default) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/contrib/sessions/backends/base.py"", line 147, in _get_session\n self._session_cache = self.load() 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/contrib/sessions/backends/db.py"", line 19, in load\n return self.decode(s.session_data) 
[Fri Aug 15 08:52:23 2008] [error] [client 192.168.0.222] File ""/usr/local/lib64/python2.5/site-packages/django/contrib/sessions/backends/base.py"", line 80, in decode\n encoded_data = base64.decodestring(session_data)

}}}
"		closed	Uncategorized	dev		fixed			Accepted	0	0	0	0	0	0