下面是sqlldr命令执行报的错，在windows下执行没有问题，REMK字段40长度够了，但是在unix上就得76.

百思不得其解。

文件是在本地以UTF-8格式，并去BOM头，上传到UNIX的。

请各位帮忙。


Control File: cmm_ckptpara.ctl
Data File: cmm_ckptpara.bad
  Bad File: cmm_ckptpara.bad
  Discard File: none specified
  
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table CMM_CKPTPARA, loaded from every logical record.
Insert option in effect for this table: APPEND
  Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
PRCD FIRST * , O(") CHARACTER   
PAID NEXT * , O(") CHARACTER   
REMK NEXT * , O(") CHARACTER   
VALU NEXT * , O(") CHARACTER   
STAT NEXT * , O(") CHARACTER   
Record 1: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Record 2: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Record 3: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Record 4: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Table CMM_CKPTPARA:
  0 Rows successfully loaded.
  4 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Space allocated for bind array: 82560 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 4
Total logical records rejected: 4
Total logical records discarded: 0
Run began on Sun May 15 16:23:37 2011
Run ended on Sun May 15 16:23:37 2011
Elapsed time was: 00:00:00.14
CPU time was: 00:00:00.05

下面是sqlldr命令执行报的错，在windows下执行没有问题，REMK字段40长度够了，但是在unix上就得76.

百思不得其解。

文件是在本地以UTF-8格式，并去BOM头，上传到UNIX的。

请各位帮忙。


Control File: cmm_ckptpara.ctl
Data File: cmm_ckptpara.bad
  Bad File: cmm_ckptpara.bad
  Discard File: none specified
  
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table CMM_CKPTPARA, loaded from every logical record.
Insert option in effect for this table: APPEND
  Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
PRCD FIRST * , O(") CHARACTER   
PAID NEXT * , O(") CHARACTER   
REMK NEXT * , O(") CHARACTER   
VALU NEXT * , O(") CHARACTER   
STAT NEXT * , O(") CHARACTER   
Record 1: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Record 2: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Record 3: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Record 4: Rejected - Error on table CMM_CKPTPARA, column REMK.
ORA-12899: value too large for column "HRFXIP"."CMM_CKPTPARA"."REMK" (actual: 76, maximum: 40)
Table CMM_CKPTPARA:
  0 Rows successfully loaded.
  4 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Space allocated for bind array: 82560 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 4
Total logical records rejected: 4
Total logical records discarded: 0
Run began on Sun May 15 16:23:37 2011
Run ended on Sun May 15 16:23:37 2011
Elapsed time was: 00:00:00.14
CPU time was: 00:00:00.05