db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lance J. Andersen" <Lance.Ander...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-695) Re-enable the TINYINT datatype
Date Thu, 10 Nov 2005 00:11:08 GMT

>>8-bit integer.
>>    
>>
>
>I see this in section 8.3.4
>
>"The JDBC type TINYINT represents an 8-bit integer value between 0 and
>255 that may be signed or unsigned."
>
>I don't see anything in that section or elsewhere about "fits in a
>byte", in fact I see:
>
>"The 8-bit Java byte type represents a signed value from -128 to 127, so
>it may not always be appropriate for larger TINYINT values"
>
>Maybe you could read the first quote as unsigned 0-255, and signed
>-128-127 but it seems a strange way of saying that.
>
>Maybe there's a better definition somewhere, that's just the first I
>found, since it doesn't seem to be mentioned in JDBC 3.0 in any
>meaningful way.
>  
>
Nope the only section which discusses this is Appendix B which indicates 
the equivalent Java type is a byte.

-lance

>
>But I'm tired and jet-lagged ...
>
>Dan.
>
>
>
>
>  
>

Mime
View raw message