Re: loaddata encoding problem

Hi Ian, I do have NVARCHAR2 columns and the NLS_NCHAR_CHARACTERSET is AL16UTF16 in both schemas. When trying to decode and encode according to your instruction I get: UnicodeEncodeError: 'latin-1' codec can't encode characters in position 4171134-4176189: ordinal not in range(256) When looking

Re: loaddata encoding problem

On Dec 1, 9:29 am, Johan 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

loaddata encoding problem

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