0 Replies Latest reply: Nov 28, 2012 10:34 AM by 974139 RSS

    Uploading data to the cloud database characterset problem

    974139
      We have an issue containing data upload though the Oracle cloud database.

      I uploaded our data to the cloud database using the cart function of SQLDeveloper.
      The created (sqlloader) log files show discarded records.
      Not all data is discarded. The data which contains special characters (like 'éä' etc) is scrambled.

      When I open the *.ldr files in the created zip file the data looks fine.

      It seems to be a character set problem.

      My source database settings:
      NLS_LANGUAGE=DUTCH
      NLS_TERRITORY=THE NETHERLANDS
      NLS_CHARACTERSET=WE8MSWIN1252
      Oracle database 11G

      I read in the manual that the cloud database is using UTF8. I expect the import process (SQLLoader) should take care of the character conversion.

      When I make an export script with SQLDeveloper from a set of tables the data is imported successfull, but that one has limitations because it can't handle clob and blob datatypes. It also is more work because of disabling/enabling referential contraints and truncating data. So I would like to use the cart option of SQLDeveloper.

      Is there a solution for this issue?