如下，有一存储过程：
- SQL code
CREATE PROCEDURE dbo.InsertKfSndHis/* [ (@param_name datatype [= default] [output] ), ... ] */@UserId char(11)='',@Gate char(20)='0',@SpNumber char(20)='0',@UserNumber char(20)='',@Msg varchar (200)='',@PtMsgId char (20)='',@SpMsgId char (25)='',@sDate char (10)='',@sTime char (10)='',@SendType int=1,@MobiType int=0,@ReportFlag int=0,@SendWay int=-1,@SendFlag int=-1,@SplitCnt int=0AS BEGIN INSERT INTO kf_snd_history (UserId,SpGate,SpNumber,UserNumber,Msg,PtMsgId,SpMsgId,sDate,sTime,SendType,MobiType,ReportFlag,SendWay,SendFlag,SplitCnt) VALUES (@UserId,@Gate, @SpNumber, @UserNumber,@Msg,@PtMsgId,@SpMsgId,@sDate,@sTime, @SendType,@MobiType,@ReportFlag, @SendWay,@SendFlag,@SplitCnt) END
用下面执行
- SQL code
EXEC InsertKfSndHis '13600000412', '518', '518001', '15800000000', '齼意abc123', '10000001', '1228192206106281', '2009-12-28', '19:22:09', 3, 0, 1, 2, 0,1
执行失败，错误是：
Procedure 'InsertKfSndHis', Line 0:
Error converting characters into server's character set. Some character(s) could not be converted.
(return status = -6)
请问下是什么原因导致的呢？谢谢了
------解决方案--------------------------------------------------------
跟服务器字符集有关系
------解决方案--------------------------------------------------------
设置成cp936