Error converting data type int to tinyint

Question

I am new to stored procedures. When i run this i get an error saying Error converting data type int to tinyint. In my C# was the following code:

mySqlcmd.CommandText = "EXECUTE PhoneNumber_Insert  @p_PhoneNumberTypeID, @p_PersonID";
mySqlcmd.Parameters.Add("@p_PhoneNumberTypeID", SqlDbType.TinyInt).Value = 1;
mySqlcmd.Parameters.Add("@p_PersonID", SqlDbType.Int).Value = "754381";
mysqlConnection.Open();
mySqlcmd.ExecuteNonQuery();
mysqlConnection.Close();

Cast the 1 to a byte (mySqlcmd.Parameters.Add("@p_PhoneNumberTypeID", SqlDbType.TinyInt).Value = (byte) 1;). Let me know if it works and I'll write it up as an answer — Flydog57
– Flydog57, Commented Dec 25, 2020 at 1:26
post your stored proc. definition. You might have your param types the wrong way around.... — Mitch Wheat
– Mitch Wheat, Commented Dec 25, 2020 at 2:10
"PhoneNumber_Insert expects parameter @PhoneNumberTypeId which was not supplied" mySqlcmd.Parameters.Add("@p_PhoneNumberTypeID", SqlDbType.TinyInt).Value= (byte)1; — Automation89
– Automation89, Commented Dec 25, 2020 at 2:20
mySqlcmd.Parameters.Add("@p_PersonID", SqlDbType.Int).Value = "754381"; Why are you passing this as a string? — mjwills
– mjwills, Commented Dec 25, 2020 at 4:12

Bradley Grainger · Accepted Answer · 2020-12-26 16:57:28Z

2

You're encountering bug 101302 in MySQL Connector/NET. There are three possible workarounds:

Change your code to explicitly use MySqlDbType.Byte: mySqlcmd.Parameters.Add("@p_PhoneNumberTypeID", MySqlDbType.Byte).Value = 1;
Downgrade to MySql.Data 8.0.21.
Switch to MySqlConnector, which supports the same API as MySql.Data but is less buggy.

answered Dec 26, 2020 at 16:57

Bradley Grainger

28.3k4 gold badges95 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bradley Grainger Over a year ago

@MitchWheat It's a problem that happens with various data types; see the duplicated bug report: bugs.mysql.com/bug.php?id=101424. That bug report just provided reproduction steps for BOOL.

Collectives™ on Stack Overflow

Error converting data type int to tinyint

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related