problem in loading foreign characters [message #506064] |
Fri, 06 May 2011 06:46 |
|
blackpawn
Messages: 1 Registered: May 2011 Location: india
|
Junior Member |
|
|
hi all,
below is the part of my control file trying to load some european characters of which some are 2bytes.so positioning is getting changed. (eg. for the first field apart from taking 10 characters as length it is taking 8 due to the existance of 2 foreign characters.)
Load DATA
CHARACTERSET AL32UTF8
LENGTH SEMANTICS CHARACTER
append
INTO TABLE UD_STAGING
TRAILING NULLCOLS
(
id position(1:30) char "trim(:id)",
value position(31:40) char "trim(:value)"
)
INTO TABLE UDFLOAD_STAGING
TRAILING NULLCOLS
(
id position(1:30) char "trim(:id)",
value position(41:50) char "trim(:value)"
)
...
....
...
INTO TABLE UDFLOAD_STAGING
TRAILING NULLCOLS
(
id position(1:30) char "trim(:id)",
value position(201:210) char "trim(:value)"
)
thanks in advance
|
|
|