Importing UTF-8 data
I have a need to import a number of data files that have arabic and spanish characters (and others). If I cut and paste the data from the text file (or csv or word or excel) column by column I can insert/update the data using sql*developer and commit the data and query the data and it returns in the correct format.
The challenge here is obvious, cutting and pasting 1000's of records is not neccessarily my best use of time. But when I "import" the data using sql*developer it seems to work fine....except
the data didn't convert and I get funky characters.
Of course I can then cut and paste the offending column from the original document and it works fine.
Is there an option or setting on the import feature of sql*developer that I am missing out on?
Thank you in advance,
Orest