#1050 MSSQL tinyint: problems with values >127

open
nobody
5
2016-09-14
2012-10-05
John Hardin
No

MSSQL tinyint (unsigned byte) data type has problems when the value is > 127.

(1) cannot enter values > 127 when editing data grid

(2) values > 127 displayed as negative numbers
demo:
SELECT TOP (255) CAST(ROW_NUMBER() OVER (ORDER BY object_id) AS tinyint) FROM sys.tables

(3) cannot enter values -1 ... -128 when editing data grid

See related MYSQL and Sybase bugs.

Discussion

  • James Toebes

    James Toebes - 2016-09-14

    Downloaded SquirrelFX snapshot squirrelsqlfx-snapshot-20160821_1917.zip to compare. It is no where near as ready for daily use as the main Squirrel. It shows proper values above 127 with the same drivers.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks