On Dec 1, 9:29 am, Johan <[email protected]> wrote:
> Hi,
>
> I have two oracle schemas created with the same characterset
> (NLS_CHARACTERSET = WE8ISO8859P1).
>
> I get a "DatabaseError: ORA-12704: character set mismatch" when doing
> this:
> 1) dumpdata to export data from a module named log in the first schema
> and then
> 2) loaddata to import the result into the second schema.
>
> Stacktrace:
>
> Problem installing fixture '../../data/fixtures/dev/r1797_20091201/
> log.xml': Traceback (most recent call last):
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> core/management/commands/loaddata.py", line 153, in handle
> obj.save()
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> core/serializers/base.py", line 163, in save
> models.Model.save_base(self.object, raw=True)
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> db/models/base.py", line 495, in save_base
> result = manager._insert(values, return_id=update_pk)
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> db/models/manager.py", line 177, in _insert
> return insert_query(self.model, values, **kwargs)
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> db/models/query.py", line 1087, in insert_query
> return query.execute_sql(return_id)
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> db/models/sql/subqueries.py", line 320, in execute_sql
> cursor = super(InsertQuery, self).execute_sql(None)
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> db/models/sql/query.py", line 2369, in execute_sql
> cursor.execute(sql, params)
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> db/backends/util.py", line 19, in execute
> return self.cursor.execute(sql, params)
> File "/usr/lib/python2.6/site-packages/Django-1.1-py2.6.egg/django/
> db/backends/oracle/base.py", line 434, in execute
> raise e
> DatabaseError: ORA-12704: character set mismatch
>
> Why do I get this "character set mismatch" when I have the same
> character sets in the two schemas?
>
> Thanks,
> Johan
Hi Johan,
Do you only have VARCHAR2 / CLOB columns in the tables, or are there
any NVARCHAR2 / NCLOB columns (which Django creates by default)? If
the latter, then what is the NLS_NCHAR_CHARACTERSET of each database?
Also, the dumpdata output should be in utf-8. Can you verify that it
can be re-encoded as iso-8859-1 by running the code `file
('dumpdata.json').read().decode('utf-8').encode('iso-8859-1')`?
Thanks,
Ian
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
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.
