topic Using append_management to load dbf data in Python Questions https://community.esri.com/t5/python-questions/using-append-management-to-load-dbf-data/m-p/622636#M48481 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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 ,</P><P></P><P>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.</P><P></P><P>How can I control the codepage or characterset conversion when using Append_management?</P><P></P><P>Thanks,</P><P>Rob</P></BODY></HTML> Wed, 04 Feb 2015 16:14:05 GMT Rvan_Rijen 2015-02-04T16:14:05Z Using append_management to load dbf data https://community.esri.com/t5/python-questions/using-append-management-to-load-dbf-data/m-p/622636#M48481 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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 ,</P><P></P><P>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.</P><P></P><P>How can I control the codepage or characterset conversion when using Append_management?</P><P></P><P>Thanks,</P><P>Rob</P></BODY></HTML> Wed, 04 Feb 2015 16:14:05 GMT https://community.esri.com/t5/python-questions/using-append-management-to-load-dbf-data/m-p/622636#M48481 Rvan_Rijen 2015-02-04T16:14:05Z