Home » RDBMS Server » Server Utilities » problem in loading foreign characters (10g)
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
Previous Topic: issue with import
Next Topic: Difference in size of exports (.dmp) files
Goto Forum:
  


Current Time: Sat Apr 19 19:45:14 CDT 2014

Total time taken to generate the page: 0.10505 seconds