External Table Turkish character problem
Hello AllI try to create externar table.table is created but there is a problem about fetch data from table.summary of my process;
1)I have created directory as test_dir
2)Here is external table sql code
result;
BILGI
------------------------
KAH
but should be following
BILGI
------------------------
KAHRAMANMANARAŞ
Also here is txt file content
101432 0 1422 20221 6628217 6628217 RAMAZAN SÜRMELİ APARTMAN GÖREVLİSİ/E 90 49294561538 EMİNE SÜLEYMAN TÜYLÜ GÖKSUN 1980081002 1 1 C09136904 (1046)KAHRAMANMARAŞ(1059) GÖKSUN KAVŞUT 0035 00041 0095 GÖKSUN 2004011349294561538
1)I have created directory as test_dir
2)Here is external table sql code
create table test(
bilgi CHAR(13) NULL
)
organization external (
default directory yts2dcs
access parameters (
records delimited by newline
BADFILE 'emre.bad'
LOGFILE 'emre.log'
fields (
bilgi position(1046:1059) CHAR(13)
)
)
location ('emre.txt')
)
reject limit unlimited
;
3)Select * from test;result;
BILGI
------------------------
KAH
but should be following
BILGI
------------------------
KAHRAMANMANARAŞ
Also here is txt file content
101432 0 1422 20221 6628217 6628217 RAMAZAN SÜRMELİ APARTMAN GÖREVLİSİ/E 90 49294561538 EMİNE SÜLEYMAN TÜYLÜ GÖKSUN 1980081002 1 1 C09136904 (1046)KAHRAMANMARAŞ(1059) GÖKSUN KAVŞUT 0035 00041 0095 GÖKSUN 2004011349294561538
0