search

hassanakbar4 / ttest

0 stars 0 forks source link

Convert tables to UTF-8 #337

Closed hassanakbar4 closed 12 years ago

hassanakbar4 commented 14 years ago

resolution_fixed type_defect | by pasi.eronen@nokia.com

Currently, code like

res = InternetDraft.objects.filter(title=u"\u3145")

results in exception:

OperationalError: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='")

Under test/, there's a script "find_non_ascii.py" that can be used to find non-ASCII data for testing.

Some information about converting the tables:

http://michaelangela.wordpress.com0a5d2fcfcb82276aeac0336091fe77bda6b3f96bsnippet-to-update-django-tables-to-utf8/ http://www.bothernomore.com0a5d2fcfcb82276aeac0336091fe77bda6b3f96bcharacter-encoding-hell/

Issue migrated from trac:337 at 2021-12-13 14:44:04 +0500

hassanakbar4 commented 12 years ago

@henrik@levkowetz.com changed status from new to closed

hassanakbar4 commented 12 years ago

@henrik@levkowetz.com changed resolution from ` tofixed`

hassanakbar4 commented 12 years ago

@henrik@levkowetz.com commented

Fixed by the conversion to new database schema, which is all in utf-8.