当前位置: 代码迷 >> Sybase >> sybase bcp 有关问题
  详细解决方案

sybase bcp 有关问题

热度:6201   发布时间:2013-02-26 00:00:00.0
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

?