AnsweredAssumed Answered

Using append_management to load dbf data

Question asked by rvrijen on Feb 4, 2015

Hi,

 

I am using arcpy.Append_management to load data from a dbf file on a Windows server into an Oracle 10.2.0.4 database. The dbf file is encoded in we8mswin1252, the database is in al32utf8. The special charaters are not inserted correctly into the database, é for instance becomes ,

 

I have tried to set the NLS_LANG settings in the Windows environment, but this does not help. I have tried to alter the session using arcpy.ArcSDESQLExecute, but this also does not seem to work.

 

How can I control the codepage or characterset conversion when using Append_management?

 

Thanks,

Rob

Outcomes