Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1050 MSSQL tinyint: problems with values >127

open
nobody
5
2012-12-29
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