Issue with TinyInt


Author
Message
StrataFrame Team
S
StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Good link Greg.  There's a lot of good info in SQL Server Books Online.
StrataFrame Team
S
StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Yep, it's correct, in fact, we had to put some special clase code in the BOMapper to make it map like that.  According to the GetScema() method of SqlCommand that tells the native .NET type that is supposed to support a column, it says it should be System.SByte, but that's a "signed byte" (-128 to 127) and doesn't work with tiny int which should be 0 to 255.
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.4K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Tim Dol
Tim Dol
Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)Advanced StrataFrame User (644 reputation)
Group: Forum Members
Posts: 340, Visits: 1.4K
I have set the data types for a number of fields to 'TinyInt'. These values come accross as System.Byte in the mapper. Is this correct or a small bug?


Tim

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search