Re: [jira] Commented: (DERBY-695) Re-enable the TINYINT datatype

[Lance J. Andersen]

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.