|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/main.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Data Types</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" -->
<link href="ss.css" rel="stylesheet" type="text/css">
<!-- InstanceEndEditable -->
</head>
<body bgcolor="#FFFFFF" text="#666666">
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td bgcolor="#CCCCCC"><h3><font color="#999999">DarkSide SQL Mini Help</font></h3></td>
</tr>
</table>
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
<!--DWLayoutTable-->
<tr>
<td width="164" height="305" valign="top"><table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td><a href="index.htm">Home</a></td>
</tr>
<tr>
<td><a href="intro.htm">Introduction</a></td>
</tr>
<tr>
<td><a href="using.htm">Using The Library</a></td>
</tr>
<tr>
<td><a href="api_ref.htm">API Reference</a></td>
</tr>
<tr>
<td><strong>SQL Commands</strong></td>
</tr>
<tr>
<td><div align="center"><a href="sql_ct.htm">CREATE TABLE</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_dd.htm">DROP DATABASE</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_dt.htm">DROP TABLE</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_use.htm">USE</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_i.htm">INSERT</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_u.htm">UPDATE</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_d.htm">DELETE</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_s.htm">SELECT</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="sql_o.htm">OPTIMIZE</a></div></td>
</tr>
<tr>
<td><a href="types.htm">Data Types</a></td>
</tr>
<tr>
<td><a href="oprs.htm">Operators</a></td>
</tr>
<tr>
<td><a href="bugs.htm">Bugs</a></td>
</tr>
<tr>
<td><a href="lic.htm">License</a></td>
</tr>
<tr>
<td><a href="tps.htm">Third-party software</a></td>
</tr>
<tr>
<td><a href="abt.htm">About</a></td>
</tr>
</table></td>
<!-- InstanceBeginEditable name="txt" -->
<td width="398" valign="top"><p>DataTypes</p>
<table border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td>SMALLINT</td>
<td>Integer values in the range -32768 and 32767</td>
</tr>
<tr>
<td>INT</td>
<td>Integer values in the range (-2147483647 - 1) and 2147483647</td>
</tr>
<tr>
<td>BIGINT</td>
<td>As of now, same as INT</td>
</tr>
<tr>
<td>FLOAT</td>
<td>Decimal values, 19 digits in length including 7 digit floating point
precision. </td>
</tr>
<tr>
<td>DOUBLE</td>
<td>Decimal values, 25 digits in length including 14 digit floating
point precision. </td>
</tr>
<tr>
<td>CHAR</td>
<td>Character strings with a maximum length of 255</td>
</tr>
<tr>
<td>VARCHAR</td>
<td>Character strings of unlimited size. <a href="text.htm">more...</a></td>
</tr>
<tr>
<td>DATE</td>
<td>Date values in the format YYYY-MM-DD. Use the constant 'sysdate'
to insert the system date. <a href="date.htm">more...</a></td>
</tr>
<tr>
<td>TIME</td>
<td>Time values in the format HH:MM:SS.Use the constant 'systime' to
insert the system time.</td>
</tr>
<tr>
<td valign="top">TIMESTAMP</td>
<td>A string representing the current date and time. Automatically inserted
by the database ignoring any value specified by the user.Better to
give 0 as a TIMESTAMP value in an insert</td>
</tr>
<tr>
<td>BOOL</td>
<td>TRUE,FALSE values</td>
</tr>
<tr>
<td>AUTOID</td>
<td>A BIGINT field that is automatically incremeneted by the database.
Specify 0 as its value in an INSERT</td>
</tr>
<tr>
<td>UID</td>
<td> A unique ID same as AUTOID, but a random value created from the
system time.</td>
</tr>
</table>
<p> </p></td>
<!-- InstanceEndEditable --></tr>
<tr>
<td height="58" colspan="2" valign="top"><div align="center">© 2003 <a href="mailto:vijaymathewp@yahoo.co.in">LogicMatrix</a></div></td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Submit an article or tip