Issue while uploading positional mix byte data file using Sql Loader
Hi,
I am trying to load positional data file using Sql Loader.
Data files having only single byte characters are getting uploaded properly.
But some Data files are having Single and Multi byte characters both. In these cases I am facing the issue.
Please find below one mix byte record that I am trying to upload and facing issue.
"C000001000000000000008011380249TRY92110001 100152 2012011120120111012300723034 TR080012300723003995528200 ŰNSPED PAKET SERVISI SAN VE TIC A.S0000000002954990000000000 00000023TARGET DETAILS INVALID 0000000000TARGET DETAILS INVALID (MERC_00000023) C00000000 05377738000000002 4TR "
Here is the Sql Loader control file that I am using.
LOAD DATA
CHARACTERSET UTF8
infile *
append
into table XX_TEST_STG_TBL
I am trying to load positional data file using Sql Loader.
Data files having only single byte characters are getting uploaded properly.
But some Data files are having Single and Multi byte characters both. In these cases I am facing the issue.
Please find below one mix byte record that I am trying to upload and facing issue.
"C000001000000000000008011380249TRY92110001 100152 2012011120120111012300723034 TR080012300723003995528200 ŰNSPED PAKET SERVISI SAN VE TIC A.S0000000002954990000000000 00000023TARGET DETAILS INVALID 0000000000TARGET DETAILS INVALID (MERC_00000023) C00000000 05377738000000002 4TR "
Here is the Sql Loader control file that I am using.
LOAD DATA
CHARACTERSET UTF8
infile *
append
into table XX_TEST_STG_TBL
0