db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Commented: (DERBY-695) Re-enable the TINYINT datatype
Date Thu, 10 Nov 2005 00:28:00 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
What does this mean? Section 8.3.4 at
<a class="moz-txt-link-freetext" href="http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/mapping.html">http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/mapping.html</a>.<br>
<p>"The recommended Java mapping for the <b>JDBC <code>TINYINT</code></b>
type is as either a <b>Java <code>byte</code></b> or a <b>Java
The 8-bit Java <code>byte</code> type represents a signed value from <code>-128</code>
to <code>127</code>, so <b>it may not always be appropriate</b> for
larger <code>TINYINT</code> values, whereas the <b>16-bit Java <code>short</code>
will always be able</b> to hold all <code>TINYINT</code> values."</p>
This seems to infer JDBC TINYINT range of 0-255.<br>
Lance J. Andersen wrote:<br>
<blockquote cite="mid4372901C.2000100@sun.com" type="cite">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
Nope the only section which discusses this is Appendix B which
indicates the equivalent Java type is a byte.<br>
  <blockquote cite="mid43728D62.80300@debrunners.com" type="cite">
    <pre wrap="">
But I'm tired and jet-lagged ...



View raw message