Hi all,
I am trying to use dumpdata/loaddata on a postgresql_psycopg2 backend
with a character encoding of UTF-8. The data came from a legacy DB, the
model was derived from "manage.py inspectdb". It chokes on non-ASCII
characters when dumping in XML-format:
"Unable to serialize database: 'ascii' codec can't decode byte 0xd8 in
position 0: ordinal not in range(128)"
Dumping in JSON-format works, but then fails on loaddata:
"Problem installing fixture '</path/to/fixture.json here>': 'ascii' codec
can't decode byte 0xc3 in position 0: ordinal not in range(128)"
This is a typical string encoding problem: 'ascii' is used as
default encoding when not specified otherwise with
>>> 'string here'.decode('utf-8')
or
>>> u'string here'.encode('utf-8')
respectively.
So my question boils down to:
How do I tell dumpdata/loaddata the encoding to use (and should it not be
using the database encoding?)
My setup on Debian/amd64 'testing':
Django SVN revision 5152
PostgreSQL 8.1.8
Python 2.4.4
Cheers,
Caspar Hasenclever
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
