[Sybase] 如果用BCP cmd再export/ import 遇到CP insert operation is disabled 問題

如果使用BCP 做資料庫匯出匯入時, 遇到CP insert operation is disabled 問題

Symptom:
BCP insert operation is disabled when data size is changing between client and server character sets.

Sol:

isql -Usa –P …etc

sp_configure "disable character set conversion",1

go

---------------------------------------------------------------------

如果是Oracle export/ import遇到類似問題 要改的DB 參數是

NLS_LENGTH_SEMANTICS  from byte to char…

Oracle data pump 指令參照:

http://jaychu649.blogspot.tw/2011/12/oracle-data-pump.html