开发者

Passing Integer of type 32 to the defined stored procedure in mysql of datatype INT

I am executing my stored procedure from c# and passing the param int of type Int 32 and in my sql db. I have a param which accepts datatype INT:

CREATE  PROCEDURE `SetProc`(PersonCou开发者_高级运维nt INT )

Will it work, as I read that in c# int 32 is signed whereas in mysql state it as unsigned.


Simply pass in a Uint32 which is an unsigned int with range 0 to 2^32 - 1.

BTW: According to the MySQL 5 Reference, INT defaults to a signed int. Only when adding the optional (nonstandard) attribute UNSIGNED it is an unsigned int.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜