CODEWITHSUNDEEP
c#mysql
Malcolm
Malcolm

Reputation: 1807

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`(PersonCount INT )

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

Upvotes: 0

Views: 146

Answers (1)

Daniel Hilgarth
Daniel Hilgarth

Reputation: 174299

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.

Upvotes: 1

Related Questions