mysqltinyint

MySQL TINYINT negative numbers get converted to positive values


In my setup, I have a tinyint(1) column in mysql database table. I populated it with -1 but when I fetch the values via C# EF framework, the values were coming out to be +1.


Solution

  • Turns out this a known bug "behaviour" with tinyint if connection string does not explicitly mention not to convert tinyint negative to boolean as per https://bugs.mysql.com/bug.php?id=33044.

    Edit as pointed by @ysth : the link is talking about different toolset but I guess the outcome is same for my toolset