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">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<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
<code>short</code></b>.
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>
<br>
Satheesh<br>
<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>
  <br>
-lance<br>
  <blockquote cite="mid43728D62.80300@debrunners.com" type="cite">
    <pre wrap="">
But I'm tired and jet-lagged ...

Dan.




  </pre>
  </blockquote>
</blockquote>
</body>
</html>


Mime
View raw message