On Tue, 2006-08-08 at 00:14 +0000, Niran Babalola wrote: > I've been developing a Django application using SQLite, and now I'm > trying to move over to MySQL and actually launch the site. The > application is storing data from RSS/Atom feeds using Universal Feed > Parser, which uses unicode strings for all its data. When I try to > store information from a feed into my MySQL database, I get the > following error: > > "UnicodeEncodeError: 'latin-1' codec can't encode characters in > position 75-76: ordinal not in range(256)"
It is going to help us help you if you can tell us where this error is coming from. Inside Django or inside the MySQL wrapper? > Everything worked fine with SQLite, but I haven't been able to get past > this problem with MySQL. I tried dropping the database and recreating > it with utf8 as the default encoding, but that didn't help either. Any > ideas? Regardless of what the database server is expecting, the error indicates the Python, somewhere, is trying to encode the data into latin-1 (ISO-8859-1). So you have some more looking for character encoding settings to do. I'm not enough of a MySQL user to be able to put my finger on the right point, but there are plenty of experts on this list, so somebody else might be able to spot it. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---