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