http://wiki.signature.net/index.php?action=history&feed=atom&title=ODBC_Data_Management 2026-05-13T01:19:15Z Revision history for this page on the wiki MediaWiki 1.16.0 http://wiki.signature.net/index.php?title=ODBC_Data_Management&diff=869&oldid=prev 2009-05-29T09:54:14Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 09:54, 29 May 2009</td> </tr><tr><td colspan="2" class="diff-lineno">Line 23:</td> <td colspan="2" class="diff-lineno">Line 23:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Application defined.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Application defined.</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">*</del>* Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">**</del>* Internet Basic Date/Time numeric functions.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* Internet Basic Date/Time numeric functions.</div></td></tr> <!-- diff cache key wikidb:diff:version:1.11a:oldid:868:newid:869 --> </table>

Badge http://wiki.signature.net/index.php?title=ODBC_Data_Management&diff=868&oldid=prev 2009-05-29T09:53:23Z

<p></p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 09:53, 29 May 2009</td> </tr><tr><td colspan="2" class="diff-lineno">Line 4:</td> <td colspan="2" class="diff-lineno">Line 4:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Supported&nbsp; SQL data types include the following:</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Supported&nbsp; SQL data types include the following:</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; &nbsp; &nbsp; &nbsp; </ins></div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL Type <del class="diffchange diffchange-inline"> </del>Internet Basic Type</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL Type <ins class="diffchange diffchange-inline"> </ins>Internet Basic Type</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>=============================================</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>=============================================</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_CHAR <del class="diffchange diffchange-inline"> </del>String</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_CHAR <ins class="diffchange diffchange-inline"> </ins>String</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_VARCHAR String</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_VARCHAR String</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_LONGVARCHAR String</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_LONGVARCHAR String</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_DECIMAL String/Numeric*</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_DECIMAL String/Numeric*</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_NUMERIC String/Numeric*</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_NUMERIC String/Numeric*</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_BIT <del class="diffchange diffchange-inline"> </del>String(1)/Numeric(1.0)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_BIT <ins class="diffchange diffchange-inline"> </ins>String(1)/Numeric(1.0)</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_TINYINT String(4)/Numeric(3.0)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_TINYINT String(4)/Numeric(3.0)</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_INTEGER String(11)/Numeric(10.0)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_INTEGER String(11)/Numeric(10.0)</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_SMALLINT String(6)/Numeric(5.0)</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_SMALLINT String(6)/Numeric(5.0)</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_REAL <del class="diffchange diffchange-inline"> </del>String(13)**</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_REAL <ins class="diffchange diffchange-inline"> </ins>String(13)**</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_DOUBLE String(22)**</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_DOUBLE String(22)**</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_DATE <del class="diffchange diffchange-inline"> </del>String(6)/Numeric(6.0)***</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_DATE <ins class="diffchange diffchange-inline"> </ins>String(6)/Numeric(6.0)***</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_TIME <del class="diffchange diffchange-inline"> </del>String(6)/Numeric(6.0)***</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_TIME <ins class="diffchange diffchange-inline"> </ins>String(6)/Numeric(6.0)***</div></td></tr> <tr><td class='diff-marker'>-</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SQL_TIMESTAMP <del class="diffchange diffchange-inline"> </del>String(13)&nbsp; - special “dddddd.ssssss” format</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">&nbsp; </ins>SQL_TIMESTAMP <ins class="diffchange diffchange-inline"> </ins>String(13)&nbsp; - special “dddddd.ssssss” format</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Application defined.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* Application defined.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*** Internet Basic Date/Time numeric functions.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*** Internet Basic Date/Time numeric functions.</div></td></tr> <!-- diff cache key wikidb:diff:version:1.11a:oldid:867:newid:868 --> </table>

Badge http://wiki.signature.net/index.php?title=ODBC_Data_Management&diff=867&oldid=prev 2009-05-29T09:51:11Z

<p>New page: &#39;&#39;&#39;ODBC Data Management&#39;&#39;&#39; &#39;&#39;&#39;Data Types&#39;&#39;&#39; Supported SQL data types include the following: SQL Type Internet Basic Type ============================================= SQL_CHAR St...</p> <p><b>New page</b></p><div>'''ODBC Data Management'''<br /> <br /> '''Data Types'''<br /> <br /> Supported SQL data types include the following:<br /> <br /> SQL Type Internet Basic Type<br /> =============================================<br /> SQL_CHAR String<br /> SQL_VARCHAR String<br /> SQL_LONGVARCHAR String<br /> SQL_DECIMAL String/Numeric*<br /> SQL_NUMERIC String/Numeric*<br /> SQL_BIT String(1)/Numeric(1.0)<br /> SQL_TINYINT String(4)/Numeric(3.0)<br /> SQL_INTEGER String(11)/Numeric(10.0)<br /> SQL_SMALLINT String(6)/Numeric(5.0)<br /> SQL_REAL String(13)**<br /> SQL_DOUBLE String(22)**<br /> SQL_DATE String(6)/Numeric(6.0)***<br /> SQL_TIME String(6)/Numeric(6.0)***<br /> SQL_TIMESTAMP String(13) - special “dddddd.ssssss” format<br /> <br /> * Application defined.<br /> ** Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.<br /> *** Internet Basic Date/Time numeric functions.</div>

Badge