I'm migrating a site to Django. The old site was PHP/MySQL with MySQL having a default encoding of latin1. It seems like there are also Windows 1252 encodings but I'm not sure.
I have the old database and the new Django UTF8 one side by side and have a migration script that uses raw MySQLdb to connect to the old, and Django's ORM to connect to the new. Is there anything I can do to ensure the data going into the new is UTF8? To further complicate things, once the data is in the new UTF8 database, I have a script that exports to a CSV file for a client to use a subset of the data. And right now this is all sorts of fail for me. I tried using the Django snippet here: http://www.djangosnippets.org/snippets/993/ but am essentially getting what the first commenter says unless I import as Windows 1252 — then the boxes turn into quotes and apostrophes that look right. Character encodings are a big confusion for me. Thanks for any help, Rob --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
