AnsweredAssumed Answered

Using append_management to load dbf data

Question asked by rvrijen on Feb 4, 2015



I am using arcpy.Append_management to load data from a dbf file on a Windows server into an Oracle 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?