Your database characterset is single byte (AR8ISO8859P6) and you are trying to read a file in a multibyte character set (UTF8).
For a correct conversion of the data use CHARACTERSET UTF8 in the EXTERNAL TABLE definition.
stringclause identifies the character set of the datafile. If a character set is not specified, the data is assumed to be in the default character set for the database. See string.
Removed the apostrophes around UTF8
Can you please write an example how to set charset in external table definition.
Our external table has four column. One of them will have arabic fields.
I tried to find example in the link you provided for this but i didn't. Maybe because i am using my mobile.
It is appreciated if you can do that.
Thanks and regards
Here are some examples I found:
Apparently the characterset name is not surrounded by qoutes, I edited my earlier post accordingly
Please remember to specify AL32UTF8, not UTF8.