欢迎来到Doc100.Net免费学习资源知识分享平台!
您的位置:首页 > 程序异常 >

sybase bcp 有关问题

更新时间: 2014-01-05 02:21:05 责任编辑: Author_N1

 

sybase bcp 问题

2010-05-20 23:16:27.610[ INFO][RunCommandThread.run()][Thread-225] - exit code is runcmd.getExitCode()0
2010-05-20 23:16:27.612[ INFO][Solaris.runCommand()][Thread-194] - cmd=/opt/U2000/server/common/trans_core/databasescripts/patch/V100R002C00CP0101/patch_trans_common_20100508193752.sh 123456 en_US, env={}, result={errcode=0, screen=
Starting copy...
Server Message: DBSVR - Msg 4847, Level 16, State 1:
BCP insert operation is disabled when data size is changing between client and server character sets. Please use BCP's -Y option to invoke client-side conversion.

Server Message: DBSVR - Msg 3621, Level 10, State 0:
Command has been aborted.

CTLIB Message:  - L1/O3/S0/N14/0/0:
blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.
blk_init failed.
bcp copy in failed

Starting copy...

420 rows copied.
Clock Time (ms.): total = 26  Avg = 0 (16153.85 rows per sec.)

Starting copy...
Server Message: DBSVR - Msg 4847, Level 16, State 1:
BCP insert operation is disabled when data size is changing between client and server character sets. Please use BCP's -Y option to invoke client-side conversion.

Server Message: DBSVR - Msg 3621, Level 10, State 0:
Command has been aborted.

CTLIB Message:  - L1/O3/S0/N14/0/0:
blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.
blk_init failed.
bcp copy in failed

Starting copy...
Server Message: DBSVR - Msg 4847, Level 16, State 1:
BCP insert operation is disabled when data size is changing between client and server character sets. Please use BCP's -Y option to invoke client-side conversion.

Server Message: DBSVR - Msg 3621, Level 10, State 0:
Command has been aborted.

CTLIB Message:  - L1/O3/S0/N14/0/0:
blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.
blk_init failed.
bcp copy in failed
(0 rows affected)
(0 rows affected)
(371 rows affected)
(371 rows affected)
(63 rows affected)
(63 rows affected)

 

 

Sort Order Description

 ------------------------------
 Character Set = 190, utf8
     Unicode 3.1 UTF-8 Character Set
     Class 2 Character Set
 Sort Order = 50, bin_utf8
     Binary sort order for the ISO 10646-1, UTF-8 multibyte encodin
     g character set (utf8).
(return status = 0)

 

root@V44022677 # echo $LANG
en_US.UTF-8
root@V44022677 #

 

 

Solaris下这个文件需要是UTF-8的
这里报server和client不一致,需要看一下执行bcp的shell窗口是否语言不是GB18030

 

上一篇:上一篇
下一篇:下一篇

 

随机推荐程序问答结果

 

 

如对文章有任何疑问请提交到问题反馈,或者您对内容不满意,请您反馈给我们DOC100.NET论坛发贴求解。
DOC100.NET资源网,机器学习分类整理更新日期::2014-01-05 02:21:05
如需转载,请注明文章出处和来源网址:http://www.doc100.net/bugs/t/8749/
本文WWW.DOC100.NET DOC100.NET版权所有。