This discussion is archived
0 Replies Latest reply: Nov 28, 2012 8:34 AM by 974139 RSS

Uploading data to the cloud database characterset problem

974139 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points