存储过程的有关问题

存储过程的问题
如下，有一存储过程：

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

查看更多 下一篇