Data types backwards on stored procedure?
Posted: Thu 11 Dec 2008 22:27
I'm calling a stored procedure with many parameters, two of which are:
inout tinyIntVal tinyint, inout smallIntVal smallint
I add two Parameters to the command:
MySqlType = TinyInt, value = 77 (sbyte)
MySqlType = SmallInt, value = 55 (short)
After executing the procedure, the tinyint parameter has a value of 77 (short), and the smallint has a value of 55 (byte). Shouldn't the types be the other way around? Also, the tinyint parameter should come back as an sbyte, shouldn't it?
I'm using version 5.0.12.0
inout tinyIntVal tinyint, inout smallIntVal smallint
I add two Parameters to the command:
MySqlType = TinyInt, value = 77 (sbyte)
MySqlType = SmallInt, value = 55 (short)
After executing the procedure, the tinyint parameter has a value of 77 (short), and the smallint has a value of 55 (byte). Shouldn't the types be the other way around? Also, the tinyint parameter should come back as an sbyte, shouldn't it?
I'm using version 5.0.12.0