Menu

#839 Tinyint type display as error if value >127 Take 2

open
nobody
None
5
2012-12-29
2010-03-14
Anonymous
No

I have a MYQL database with 3 tinyint fields. If the value stored in any of
those fields is greater than 127, then SQuirrel 3.1 displays as error.
I'm running MySQL 4.0.12 and it's worked for years. I just downloaded
SQLYog and it displays correctly.

Thanks

Discussion

  • Rob Manning

    Rob Manning - 2010-03-14

    OK - how do you insert those values since they are not legal values according to MySQL ?

    Rob

     
  • Pat F

    Pat F - 2010-04-03

    Hello, Through Squirrel 3.1 the table shows as tinyint unsigned, but value greater than 127
    show error. I have attached screen shot from Squirrel 3.1.
    Thanks
    -P

     

Log in to post a comment.