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?