Where are the unsigned numeric types ? How do I use them?

[cesarvegamx]

I have a database with an unsigned integer column.

But, in the enumeration of MySqlType, I don't see any of the unsigned types.

In order to perform parameterized queries, which type am I supposed to use to create the parameter ?

[Alexey]

You should use CoreLab.MySql.MySqlType.Int type. If you pass negative value to the query, it will be converted to zero.

[cesarvegamx]

Really?, welll, my code returns me an error, when I do that:

An exception of type 'System.InvalidCastException' occurred in CoreLab.Data.dll but was not handled in user code
Additional information: Cannot convert parameter value of type 'System.UInt32' to MySQL type 'MySqlType.Int'.

Code: Select all

uint unsig = 4000000000;

MySqlParameter myp = new MySqlParameter("_UInt32Col", MySqlType.Int);
myp.Value = unsig;
comm.Parameters.Add(myp);

This is the first time I'm trying to use a data type not directly supported in the DbType enumeration.

I'd appreciate a snippet.

[Alexey]

This happened because you used boundary value. I suggest you not using MySqlType enumeration at all:

Code: Select all

uint unsig = 4000000000; 
MySqlParameter myp = new MySqlParameter("_UInt32Col", unsig); 
comm.Parameters.Add(myp);