| Multibyte shift columns [message #670085] |
Mon, 04 June 2018 06:58  |
 |
Yiel
Messages: 3
Registered: June 2018
|
Junior Member |
|
|
Hi everybody,
Im having a problem while loading a table with SQL Loader because of multibyte chars.
My table is:
CREATE TABLE TEST_UMLAUT
(COL1 VARCHAR2(99 CHAR),
COL2 VARCHAR2(3 CHAR),
COL3 VARCHAR2(3 CHAR),
COL4 VARCHAR2(3 CHAR),
COL5 VARCHAR2(7 CHAR),
COL6 VARCHAR2(200 CHAR)
);
My controlfile is:
LOAD DATA
CHARACTERSET AL32UTF8
INFILE '$FICHIER' BADFILE '$BAD'
APPEND
PRESERVE BLANKS
INTO TABLE TEST_UMLAUT
(
COL1 POSITION(1:99) CHAR,
COL2 POSITION(100:102) CHAR,
COL3 POSITION(103:105) CHAR,
COL4 POSITION(106:108) CHAR,
COL5 POSITION(109:115) CHAR
)
And my data line (7 spaces after the last I) is:
AAAAÖABCDEFGHIÖJKLMNABCDEFGHI
My result should be:
COL1=AAAAÖABCDEFGHIÖJKLMN
COL2=ABC
COL3=DEF
COL4=GHI
COL5= (7 spaces)
But i get:
COL1=AAAAÖABCDEFGHIÖJKL
COL2=MNA
COL3=BCD
COL4=EFG
COL5=HI (with 5 spaces at the end).
Can someone help me to get expected result?
Regards
Yiel
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Multibyte shift columns [message #670112 is a reply to message #670110] |
Wed, 06 June 2018 08:56  |
|
Yiel
Messages: 3
Registered: June 2018
|
Junior Member |
|
|
Thanks for the help guys,
I used finally a stage table with 1 column and it works fine, but the client didnt want to change all the flows we have (10 flows with more than 200 columns each) so finally the client accepted to convert the source file with sed so we wont find multibyte chars in the final flat file.
Regards
Yiel
[Updated on: Wed, 06 June 2018 08:57] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
