<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Appendix - Supported Datatypes</title>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../docs.css" rel="stylesheet" type="text/css">
<script language="JavaScript1.2" src="../docs.js"></script>
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body>
<table width="100%" class="lightblue" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><a href="http://www.omnidex.com"><img src="../images/flatlogo.gif" width="95" height="25" hspace="3" vspace="3" border="0"></a></td>
    <td><img src="../images/omnidex.gif" width="109" height="25" hspace="3" vspace="3"></td>
    <td align="right" valign="top"><p class="banner"><a href="../Contents.htm">Contents</a> 
        | <a href="../Quick%20Links.htm">Quick Links</a></p></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="175" class="bar"><p class="banner">&nbsp;</p></td>
    <td align="right" class="bar"> <!-- InstanceBeginEditable name="Section Title" -->
      <h1>Appendix</h1>
      <!-- InstanceEndEditable --></td>
  </tr>
  <tr> 
    <td width="175" class="left1 lightblue"><img src="../images/blank.gif" width="10" height="20"> 
    </td>
    <td valign="top" class="left1 lightblue">&nbsp; </td>
  </tr>
  <tr> 
    <td width="175" valign="top" class="left"><!-- InstanceBeginEditable name="leftnav" --> 
      <p><a href="#textual">Textual Data types</a></p>
      <p><a href="#binary">Binary Data types</a></p>
      <p><a href="#date">Date Data types</a></p>
      <p><a href="#other">Other Data types</a></p>
      <p><a href="#declare">Declaring Data types</a></p>
      <p><a href="#unicode">Limited UNICODE Support</a></p>
      <p><a href="#list">Quick Reference</a></p>
      <p><a href="#back">Backward Compatibility</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="Appendix.htm">Appendix</a></p>
      <p><a href="Cardinality.htm">Cardinality</a></p>
      <p><a href="Date%20Formats.htm">Date Formats</a></p>
      <p><a href="Environment%20Variables.htm">Environment Variables</a></p>
      <p><a href="File%20Name%20Handling.htm">File Name Handling</a></p>
      <p><a href="Glossary%20A.htm">Glossary</a></p>
      <p><a href="Null.htm">Null</a></p>
      <p><a href="Operating%20Limits.htm">Operating Limits</a></p>
      <p><a href="Reserved%20Words.htm">Reserved Words</a></p>
      <p>Supported Data types</p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>Supported Data types</h2>
      <p>Omnidex supports the most common RDBMS data types, as well as some Omnidex 
        specific data types for flat file databases. </p>
      <p>Data types are used in the column definitions in the <a href="../Environment%20Catalog/Environment%20Catalog.htm">Omnidex 
        environment catalog</a>.</p>
      <p>Textual and binary data types are declared with a length parameter, indicating 
        the maximum size of the data in that column. The length is passed as a 
        parameter of the data type, enclosed in parenthesis immediately following 
        the data type.</p>
      <p class="ex">datatype(length)</p>
      <p>Several data types that have only one legal length, like ORACLE DATETIME 
        and TINYINT, have default lengths that are used, and therefore do not 
        require a length parameter value.</p>
      <p class="ex">datatype</p>
      <p>The following sections divide the data types into four distinct categories 
        and provide descriptions and examples of each.</p>
      <ul>
        <li><a href="#textual">Textual Data types</a></li>
        <li><a href="#binary">Binary Data types</a></li>
        <li><a href="#date">Date Data types</a></li>
        <li><a href="#other">Other Data types</a></li>
      </ul>
      <p>Also in this document:</p>
      <ul>
        <li><a href="#declare">Declaring Data types</a></li>
        <li><a href="#unicode">Limited UNICODE Support</a></li>
        <li><a href="#list">Quick Reference</a></li>
        <li><a href="#variation">Text Indexing Length Variation</a></li>
        <li><a href="#back">Backward Compatibility</a></li>
      </ul>
      <p>See also: <a href="Date%20Formats.htm">Date Formats</a></p>
      <p class="line">&nbsp;</p>
      <h3><a name="textual"></a>Textual Data types</h3>
      <ul>
        <li><a href="#char">CHARACTER</a></li>
        <li><a href="#cstring">C STRING</a></li>
        <li><a href="#varchar">VARCHAR</a></li>
        <li><a href="#clob">CLOB</a></li>
        <li><a href="#odxvarchar">OMNIDEX VARCHAR</a></li>
        <li><a href="#odxclob">OMNIDEX CLOB</a></li>
      </ul>
      <p>Textual data type lengths are declared by the number of characters. You 
        can abbreviate thousands, millions, kilobytes and megabytes in the length 
        argument, as follows:</p>
      <p class="indent"><strong>K</strong> - Thousands - <em>n</em>*1000 characters 
        - <em>n</em>*1000 bytes or <em>n</em> kibibytes.<br>
        <span class="ex">CHARACTER(4000) = CHARACTER(4K)</span></p>
      <p class="indent"><strong>M</strong> - Millions - <em>n</em>*1000000 characters 
        - <em>n</em>*1000000 bytes or <em>n</em> mebibytes.<br>
        <span class="ex">C STRING(3000000) = C STRING(3M)</span></p>
      <p class="indent"><strong>KB</strong> - Kilobytes - <em>n</em>*1024 characters 
        - <em>n</em>*1024 bytes or <em>n</em> kilobytes.<br>
        <span class="ex">VARCHAR(2048) = VARCHAR(2KB)</span></p>
      <p class="indent"><strong>MB</strong> - Megabytes - <em>n</em>*1048576 characters 
        - <em>n</em>*1048576 bytes or <em>n</em> megabytes.<br>
        <span class="ex">CLOB(5242880) = CLOB(5MB)</span></p>
      <p>&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="char"></a>CHARACTER</h5>
      <p>Space-padded data up to 4095 characters. CHARACTER and CHAR can be used 
        interchangeably.</p>
      <p class="ex"> COLUMN &quot;PHONE&quot; PHYSICAL &quot;phone&quot; DATATYPE 
        CHAR(12)</p>
      <p class="ex">&nbsp; </p>
      <p class="line2">&nbsp;</p>
      <h5><a name="cstring"></a>C STRING</h5>
      <p>Null-terminated data up to 64MB. See <a href="#variation">Text Indexing 
        Length Variation</a> for more restrictions on the 64MB limit.</p>
      <p class="ex"> COLUMN &quot;ADDRESS&quot; PHYSICAL &quot;address&quot; DATATYPE 
        C STRING(40)</p>
      <p class="ex">&nbsp; </p>
      <p class="line2">&nbsp;</p>
      <h5><a name="varchar"></a>VARCHAR</h5>
      <p>Non-terminated and non-padded data up to 32,767 bytes. This data type 
        may contain embedded null characters since it is not null-terminated; 
        however, it should not be used to store binary data. </p>
      <p>Use of this data type required use of <a href="../Development/OmniAccess%20API/Functions/OADESCRIBE.htm">oadescribe</a> 
        and <a href="../Development/OmniAccess%20API/Functions/OABIND.htm">oabind</a> 
        so that the data-lengths variables can be used. This allows applications 
        to know the length of the data in this column for each row returned.</p>
      <p><img src="../images/note.gif" width="12" height="15">This data type is 
        not appropriate for fixed length flat files since the data length cannot 
        be stored. Flat files databases should use CHARACTER, C STRING or OMNIDEX 
        VARCHAR Data types</p>
      <p class="ex"> COLUMN &quot;COMMENTS&quot; PHYSICAL &quot;company&quot; 
        DATATYPE VARCHAR(40)</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="clob"></a>CLOB</h5>
      <p>Non-terminated and non-padded data up to 64MB. See <a href="#variation">Text 
        Indexing Length Variation</a> for more restrictions on the 64MB limit.</p>
      <p>This data type may contain embedded null characters since it is not null-terminated; 
        however, it should not be used to store binary data. </p>
      <p>Use of this data type required use of <a href="../Development/OmniAccess%20API/Functions/OADESCRIBE.htm">oadescribe</a> 
        and <a href="../Development/OmniAccess%20API/Functions/OABIND.htm">oabind</a> 
        so that the data-lengths variables can be used. This allows applications 
        to know the length of the data in this column for each row returned.</p>
      <p>The handling of CLOB data may be more expensive than the handling of 
        CHARACTER, C STRING or VARCHAR data. It is better to use those Data types 
        if their size limitations will not be exceeded.</p>
      <p><img src="../images/note.gif" width="12" height="15">This data type is 
        not appropriate for fixed length flat files since the data length cannot 
        be stored. Flat files databases should use CHARACTER, C STRING, OMNIDEX 
        VARCHAR or OMNIDEX CLOB Data types</p>
      <p class="ex">COLUMN &quot;PR_INFO&quot; PHYSICAL &quot;pr_info&quot; DATATYPE 
        CLOB(65535)</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odxvarchar"></a>OMNIDEX VARCHAR</h5>
      <p>Non-terminated and non-padded data up to 4095 bytes. </p>
      <p>The length of the textual data is stored as the first four bytes in the 
        form of a 4-byte integer. The length is only the length of the textual 
        data and does not include the length of the integer itself. The integer 
        length is inherently of the native endian (byte order) of the machine 
        and is not necessarily aligned on a machine word boundary. </p>
      <p class="ex">COLUMN &quot;CONTACT&quot; PHYSICAL &quot;contact&quot; DATATYPE 
        OMNIDEX VARCHAR(50)</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odxclob"></a>OMNIDEX CLOB</h5>
      <p>Non-terminated and non-padded data up to 64MB. See <a href="#variation">Text 
        Indexing Length Variation</a> for more restrictions on the 64MB limit. 
      </p>
      <p>The length of the textual data is stored as the first four bytes in the 
        form of a 4-byte integer. The length is only the length of the textual 
        data and does not include the length of the integer itself. The integer 
        length is inherently of the native endian (byte order) of the machine 
        and is not necessarily aligned on a machine word boundary. </p>
      <p>The handling of CLOB data may be more expensive than the handling of 
        CHARACTER, C STRING or VARCHAR data. It is better to use those Data types 
        if their size limitations will not be exceeded.</p>
      <p class="ex">COLUMN &quot;ARTICLES&quot; PHYSICAL &quot;articles&quot; 
        DATATYPE OMNIDEX CLOB(2MB)</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h4><a name="variation"></a>Text Indexing Length Variation</h4>
      <p>The maximum amount of text that can be indexed in C STRING, CLOB, BLOB, 
        OMNIDEX CLOB, or OMNIDEX BLOB data type columns is 16MB.</p>
      <p>However, the declared length can be as high as 64MB. This length includes 
        non-printable characters embedded in the document, such as formatting 
        and line feed characters.</p>
      <p>This means that after all the non-printable characters have been removed, 
        and only plain text remains, the plain text cannot exceed 16MB.</p>
      <p>This applies to both internal database columns and external documents.</p>
      <p align="right"><a href="#">top</a></p>
      <p class="line">&nbsp;</p>
      <h3><a name="binary"></a>Binary Data Types</h3>
      <p>Omnidex supports several binary data types. The length is implied in 
        these Data types, eliminating the need to express the number of bytes.</p>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td valign="top"> <ul>
              <li><a href="#tinyint">[SIGNED] TINYINT</a></li>
              <li><a href="#utinyint">UNSIGNED TINYINT</a></li>
              <li><a href="#smallint">[SIGNED] SMALLINT</a></li>
              <li><a href="#usmallint">UNSIGNED SMALLINT</a></li>
              <li><a href="#integer">[SIGNED] INTEGER</a></li>
              <li><a href="#uinteger">UNSIGNED INTEGER</a></li>
            </ul></td>
          <td valign="top"><ul>
              <li><a href="#bigint">[SIGNED] BIGINT</a></li>
              <li><a href="#ubigint">UNSIGNED BIGINT</a></li>
              <li><a href="#float">FLOAT</a></li>
              <li><a href="#double">DOUBLE</a></li>
            </ul></td>
        </tr>
      </table>
      <p>&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="tinyint"></a>[SIGNED] TINYINT</h5>
      <p>Binary data stored in one byte from -128 to 127. This is equivalent to 
        a data type [SIGNED] INTEGER length 1.</p>
      <p class="ex">datatype TINYINT</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="utinyint"></a>UNSIGNED TINYINT</h5>
      <p>Binary data stored in one byte from 0 to 255. This is equivalent to a 
        datatype UNSIGNED INTEGER length 1.</p>
      <p class="ex">datatype UNSIGNED TINYINT</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="smallint"></a>[SIGNED] SMALLINT</h5>
      <p>Binary data stored in 2 bytes from -32768 to 32767. This is equivalent 
        to a datatype [SIGNED] INTEGER length 2.</p>
      <p class="ex">datatype SMALLINT</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="usmallint"></a>UNSIGNED SMALLINT</h5>
      <p>Binary data stored in 2 bytes from 0 to 65535. This is equivalent to 
        a datatype UNSIGNED INTEGER length 2.</p>
      <p class="ex">datatype UNSIGNED SMALLINT</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="integer"></a>[SIGNED] INTEGER</h5>
      <p>Binary data stored in 4 bytes from -2147483648 to 2147483647. This is 
        equivalent to datatype [SIGNED] INTEGER length 4.</p>
      <p>If using the &quot;old&quot; syntax, length may be 1, 2, 4, 8, in place 
        of TINYINT, SMALLINT, and BIGINT.</p>
      <p class="ex">datatype INTEGER</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="uinteger"></a>UNSIGNED INTEGER</h5>
      <p>Binary data stored in 4 bytes from 0 to 4294967296. This is equivalent 
        to datatype UNSIGNED INTEGER length 4.</p>
      <p class="ex">datatype UNSIGNED INTEGER</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="bigint"></a>[SIGNED] BIGINT</h5>
      <p>Binary data stored in 8 bytes from -( 2 ^ 63 ) to ( 2 ^ 63 ) - 1. This 
        is equivalent to datatype [SIGNED] INTEGER length 8.</p>
      <p class="ex">datatype BIGINT</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="ubigint"></a>UNSIGNED BIGINT</h5>
      <p>Binary data stored in 8 bytes from 0 to ( 2 ^ 64 ) - 1. This is equivalent 
        to datatype UNSIGNED INTEGER length 8.</p>
      <p class="ex">datatype UNSIGNED BIGINT</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="float"></a>FLOAT</h5>
      <p>Floating point data stored in 4 bytes. This is equivalent to datatype 
        FLOAT length 4.</p>
      <p class="ex">datatype FLOAT</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="double"></a>DOUBLE</h5>
      <p>Double-precision floating point data stored in 8 bytes. This is equivalent 
        to datatype FLOAT length 8.</p>
      <p class="ex">datatype DOUBLE</p>
      <p class="ex">&nbsp;</p>
      <p align="right"><a href="#">top</a></p>
      <p class="line">&nbsp;</p>
      <h3><a name="date"></a>Date Data types</h3>
      <p>Date and time Data types can accept the length within parenthesis, if 
        required. If a data type can have only one value for length, then that 
        value is the default, making it unnecessary to pass a length at all.</p>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td valign="top"> <ul>
              <li><a href="#tinyint">DATE</a></li>
              <li><a href="#time">TIME</a></li>
              <li><a href="#datetime">DATETIME</a></li>
              <li><a href="#odbcdate">ODBC DATE</a></li>
              <li><a href="#odbctime">ODBC TIME</a></li>
              <li><a href="#odbcdatetime">ODBC DATETIME</a></li>
              <li><a href="#db2date">DB2 DATE</a></li>
              <li><a href="#db2time">DB2 TIME</a></li>
              <li><a href="#db2datetime">DB2 DATETIME</a></li>
            </ul></td>
          <td valign="top"><ul>
              <li><a href="#informixdate">INFORMIX DATE</a></li>
              <li><a href="#informixdatetime">INFORMIX DATETIME</a></li>
              <li><a href="#oracledatetime">ORACLE DATETIME</a></li>
              <li><a href="#asciidate">ASCII DATE</a></li>
              <li><a href="#cdatetime">C DATETIME</a></li>
              <li><a href="#odxdate">OMNIDEX DATE</a></li>
              <li><a href="#odxtime">OMNIDEX TIME</a></li>
              <li><a href="#odxdatetime">OMNIDEX DATETIME</a></li>
            </ul></td>
        </tr>
      </table>
      <p>&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="date"></a>DATE</h5>
      <p class="ex">datatype DATE</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="time"></a>TIME</h5>
      <p class="ex">datatype TIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="datetime"></a>DATETIME</h5>
      <p class="ex">datatype DATETIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odbcdate"></a>ODBC DATE </h5>
      <p class="ex">datatype ODBC DATE</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odbctime"></a>ODBC TIME</h5>
      <p class="ex">datatype ODBC TIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odbcdatetime"></a>ODBC DATETIME</h5>
      <p class="ex">datatype ODBC DATETIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="db2date"></a>DB2 DATE </h5>
      <p class="ex">datatype DB2 DATE</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="db2time"></a>DB2 TIME</h5>
      <p class="ex">datatype DB2 TIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="db2datetime"></a>DB2 DATETIME</h5>
      <p class="ex">datatype DB2 DATETIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="informixdate"></a>INFORMIX DATE </h5>
      <p class="ex">datatype INFORMIX DATE</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="informixdatetime"></a>INFORMIX DATETIME</h5>
      <p class="ex">datatype INFORMIX DATETIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="oracledatetime"></a>ORACLE DATETIME</h5>
      <p class="ex">datatype ORACLE DATETIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="asciidate"></a>ASCII DATE</h5>
      <p>Length can be 6 or 8 (default). </p>
      <p class="ex">datatype ASCII DATE(6)</p>
      <p class="ex">datatype ASCII DATE</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="cdatetime"></a>C DATETIME</h5>
      <p class="ex">datatype C DATETIME</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odxdate"></a>OMNIDEX DATE</h5>
      <p>Length can be 2 through 8 (default).</p>
      <p>See also: <a href="Date%20Formats.htm">Data Formats</a></p>
      <p class="ex">datatype OMNIDEX DATE</p>
      <p class="ex">datatype OMNIDEX DATE(4) format MMDD</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odxtime"></a>OMNIDEX TIME</h5>
      <p>Length can be 2 through 8 (default).</p>
      <p>See also: <a href="Date%20Formats.htm">Data Formats</a></p>
      <p class="ex">datatype OMNIDEX TIME</p>
      <p class="ex">datatype OMNIDEX TIME(6) format DDHHNN</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odxdatetime"></a>OMNIDEX DATETIME</h5>
      <p>Length can be 2 through 16 (default).</p>
      <p>See also: <a href="Date%20Formats.htm">Data Formats</a></p>
      <p class="ex">datatype OMNIDEX DATETIME</p>
      <p class="ex">datatype OMNIDEX DATETIME(8) format YYMMDDHH</p>
      <p class="ex">datatype OMNIDEX DATETIME length 8</p>
      <p align="right"><a href="#">top</a></p>
      <p class="line">&nbsp;</p>
      <h3><a name="other"></a>Other Data types</h3>
      <h5><a name="blob"></a>BLOB</h5>
      <p>Binary data up to <font color="#FF0000">**</font>64MB, used for transport 
        of data such as images, video or audio files. Columns of this data type 
        may ONLY be reference in SELECT statements as a select list item.</p>
      <p>If indexed with Omnidex, the EXTRACT_TEXT option will automatically be 
        used to pull text out of binary files such as Microsoft Word and Adobe 
        PDF files.</p>
      <p>Use of this data type required use of <a href="../Development/OmniAccess%20API/Functions/OADESCRIBE.htm">oadescribe</a> 
        and <a href="../Development/OmniAccess%20API/Functions/OABIND.htm">oabind</a> 
        so that the data-lengths variables can be used. This allows applications 
        to know the length of the data in this column for each row returned.</p>
      <p><img src="../images/note.gif" width="12" height="15">This data type is 
        not appropriate for fixed length flat files since the data length cannot 
        be stored. Flat files databases should use the OMNIDEX BLOB data type.</p>
      <p><font color="#FF0000">**</font> The 64MB includes formatting tags not 
        seen in the document. These tags will be stripped and the plain text extracted. 
        The extracted text is limited to 16MB</p>
      <p class="ex"> COLUMN &quot;PHOTO&quot; PHYSICAL &quot;Photo&quot; DATATYPE 
        BLOB(65535)</p>
      <p class="ex">&nbsp; </p>
      <p class="line2">&nbsp;</p>
      <h5><a name="odxblob"></a>OMNIDEX BLOB</h5>
      <p>Binary data up to <font color="#FF0000">**</font>64MB.</p>
      <p>The length of the textual data is stored as the first four bytes in the 
        form of a 4-byte integer. The length is only the length of the textual 
        data and does not include the length of the integer itself. The integer 
        length is inherently of the native endian (byte order) of the machine 
        and is not necessarily aligned on a machine word boundary.</p>
      <p>If indexed with Omnidex, the EXTRACT_TEXT option will automatically be 
        used to pull text out of binary files such as Microsoft Word and Adobe 
        PDF files.</p>
      <p>Use of this data type required use of <a href="../Development/OmniAccess%20API/Functions/OADESCRIBE.htm">oadescribe</a> 
        and <a href="../Development/OmniAccess%20API/Functions/OABIND.htm">oabind</a> 
        so that the data-lengths variables can be used. This allows applications 
        to know the length of the data in this column for each row returned.</p>
      <p><font color="#FF0000">**</font> The 64MB includes formatting tags not 
        seen in the document. These tags will be stripped and the plain text extracted. 
        The extracted text is limited to 16MB.</p>
      <p class="ex">COLUMN &quot;PICTURE&quot; PHYSICAL &quot;Picture&quot; DATATYPE 
        OMNIDEX BLOB(65535)</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="nchar"></a>NCHAR</h5>
      <p>Space-padded data up to 32,767 characters.</p>
      <p>NCHAR is the National Character (UNICODE) data type equivalent to CHAR 
        or CHARACTER.</p>
      <p>Support for UNICODE Data types is limited. See <a href="#unicode">Limited 
        Unicode Support</a> for details.</p>
      <p class="ex"> COLUMN &quot;CUSTOMERID&quot; PHYSICAL &quot;CustomerID&quot; 
        DATATYPE NCHAR(5)</p>
      <p class="ex">&nbsp; </p>
      <p class="line2">&nbsp;</p>
      <h5><a name="ncstring"></a>NC STRING</h5>
      <p>Null-terminated data up to 64MB. See <a href="#variation">Text Indexing 
        Length Variation</a> for more restrictions on the 64MB limit. </p>
      <p>NC STRING is the National Character (UNICODE) data type equivalent to 
        C STRING.</p>
      <p>Support for UNICODE Data types is limited. See <a href="#unicode">Limited 
        Unicode Support</a> for details.</p>
      <p><img src="../images/note.gif" width="12" height="15">Because the UNICODE 
        characters are 2 bytes each, twice the size of ASCII characters, the number 
        of characters that can be contained within the 16MB extracted text limit 
        is half that of the C STRING data type.</p>
      <p>&nbsp;</p>
      <p class="ex">COLUMN &quot;PHOTOPATH&quot; PHYSICAL &quot;PhotoPath&quot; 
        DATATYPE NC STRING(255)</p>
      <p class="ex">&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="nvarchar"></a>NVARCHAR</h5>
      <p>Non-terminated and non-padded data up to 4095 bytes. </p>
      <p>NVARCHAR is the National Character (UNICODE) data type equivalent to 
        VARCHAR.</p>
      <p>Support for UNICODE Data types is limited. See <a href="#unicode">Limited 
        Unicode Support</a> for details.</p>
      <p>&nbsp;</p>
      <p class="ex">COLUMN &quot;COMPANYNAME&quot; PHYSICAL &quot;CompanyName&quot; 
        DATATYPE NVARCHAR(40)</p>
      <p class="ex">&nbsp;</p>
      <p>&nbsp;</p>
      <p class="line2">&nbsp;</p>
      <h5><a name="nclob"></a>NCLOB</h5>
      <p>Non-terminated and non-padded data up to 64MB. See <a href="#variation">Text 
        Indexing Length Variation</a> for more restrictions on the 64MB limit. 
      </p>
      <p>This data type may contain embedded null characters since it is not null-terminated; 
        however, it should not be used to store binary data.</p>
      <p>NCLOB is the National Character (UNICODE) data type equivalent to CLOB.</p>
      <p>Support for UNICODE Data types is limited. See <a href="#unicode">Limited 
        Unicode Support</a> for details.</p>
      <p><img src="../images/note.gif" width="12" height="15">Because the UNICODE 
        characters are 2 bytes each, twice the size of ASCII characters, the number 
        of characters that can be contained within the 16MB extracted text limit 
        is half that of the CLOB data type.</p>
      <p>&nbsp;</p>
      <p class="ex">COLUMN &quot;HOMEPAGE&quot; PHYSICAL &quot;HomePage&quot; 
        DATATYPE NCLOB(32767)</p>
      <p class="ex">&nbsp;</p>
      <p align="right"><a href="#">top</a></p>
      <p class="line">&nbsp;</p>
      <h3><a name="unicode"></a>Limited UNICODE Support</h3>
      <p>UNICODE data types support a 16-bit character set, as opposed to the 
        8-bit ASCII character set supported by the other textual data types. </p>
      <p> Omnidex supports NCHAR data types to the extent that the data contains 
        only characters from the ASCII character set. This means that if Omnidex 
        can convert it to an 8-bit character, it can be indexed, displayed and 
        manipulated, just like a CHAR.</p>
      <p>However, if the data contains characters not found in the ASCII character 
        set, Omnidex support is limited to transport only. This means it can be 
        stored in the database and retrieved and transported in its binary form 
        by Omnidex to the application, but any attempt by Omnidex to translate 
        or convert the data in any way, will result in an error.</p>
      <p>In technical terms, this means the 8 high-order bits of the 16-bit UNICODE 
        character must contain 0 (zeroes) in order for Omnidex to do anything 
        other than transport the data in its binary form.</p>
      <p align="right"><a href="#">top</a></p>
      <p class="line">&nbsp;</p>
      <h3><a name="list"></a>Data type Quick Reference</h3>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <th class="line"> <p>Number</p></th>
          <th class="line"> <p>Data Type</p></th>
          <th class="line"> <p>Length - Old Syntax</p></th>
          <th class="line"> <p>Length - New Syntax</p></th>
        </tr>
        <tr> 
          <td class="line"> <p>100</p></td>
          <td class="line"> <p><a href="#char"><img src="../images/arrow2.gif" width="10" height="10" border="0">CHARACTER</a></p></td>
          <td class="line"> <p># of characters</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>201</p></td>
          <td class="line"> <p><a href="#cstring"><img src="../images/arrow2.gif" width="10" height="10" border="0">C 
              STRING</a></p></td>
          <td class="line"> <p># of characters + 1</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1700</p></td>
          <td class="line"> <p><a href="#varchar"><img src="../images/arrow2.gif" width="10" height="10" border="0">VARCHAR</a></p></td>
          <td class="line"> <p># of characters</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1800</p></td>
          <td class="line"> <p><a href="#clob"><img src="../images/arrow2.gif" width="10" height="10" border="0">CLOB</a></p></td>
          <td class="line"> <p># of characters</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>102</p></td>
          <td class="line"> <p><a href="#nchar"><img src="../images/arrow2.gif" width="10" height="10" border="0">NCHAR</a></p></td>
          <td class="line"> <p># of characters * 2</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>202</p></td>
          <td class="line"> <p><a href="#ncstring"><img src="../images/arrow2.gif" width="10" height="10" border="0">NC 
              STRING</a></p></td>
          <td class="line"> <p>(# of characters + 1) * 2</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1701</p></td>
          <td class="line"> <p><a href="#nvarchar"><img src="../images/arrow2.gif" width="10" height="10" border="0">NVARCHAR</a></p></td>
          <td class="line"> <p>(# of characters) * 2</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1801</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">NCLOB</a></p></td>
          <td class="line"> <p>(# of characters) * 2</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1799</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">OMNIDEX 
              VARCHAR</a></p></td>
          <td class="line"> <p>(# of characters) + 4</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1899</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">OMNIDEX 
              CLOB</a></p></td>
          <td class="line"> <p>(# of characters) + 4</p></td>
          <td class="line"> <p># of characters</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>301</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">[SIGNED] 
              TINYINT</a></p></td>
          <td class="line"> <p>1</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>401</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">UNSIGNED 
              TINYINT</a></p></td>
          <td class="line"> <p>1</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>302</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">[SIGNED] 
              SMALLINT</a></p></td>
          <td class="line"> <p>2</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>402</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">UNSIGNED 
              SMALLINT</a></p></td>
          <td class="line"> <p>2</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>300</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">[SIGNED] 
              INTEGER</a></p></td>
          <td class="line"> <p>1, 2, 4, 8</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>400</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">UNSIGNED 
              INTEGER</a></p></td>
          <td class="line"> <p>1, 2, 4, 8</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>303</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">[SIGNED] 
              BIGINT</a></p></td>
          <td class="line"> <p>8</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>403</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">UNSIGNED 
              BIGINT</a></p></td>
          <td class="line"> <p>8</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>600</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">FLOAT</a></p></td>
          <td class="line"> <p>4, 8</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>605</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">DOUBLE</a></p></td>
          <td class="line"> <p>8</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1000</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">DATE</a></p></td>
          <td class="line"> <p>10</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1007</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">ODBC 
              DATE</a></p></td>
          <td class="line"> <p>6</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1009</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">DB2 
              DATE</a></p></td>
          <td class="line"> <p>6</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1100</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">INFORMIX 
              DATE</a></p></td>
          <td class="line"> <p>4</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1101</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">ASCII 
              DATE</a></p></td>
          <td class="line"> <p>6, 8 </p></td>
          <td class="line"> <p>6, 8 (optional, default 8)</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1102</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">OMNIDEX 
              DATE</a></p></td>
          <td class="line"> <p>1 - 4</p></td>
          <td class="line"> <p>2 - 8 (optional, default 8)</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1199</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">TIME</a></p></td>
          <td class="line"> <p>11</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1200</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">ODBC 
              TIME</a></p></td>
          <td class="line"> <p>6</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1202</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">DB2 
              TIME</a></p></td>
          <td class="line"> <p>6</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1207</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">OMNIDEX 
              TIME</a></p></td>
          <td class="line"> <p>1 - 4</p></td>
          <td class="line"> <p>2 - 8 (optional, default 8)</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1208</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">DATETIME</a></p></td>
          <td class="line"> <p>22</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1206</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">ORACLE 
              DATETIME</a></p></td>
          <td class="line"> <p>7</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1205</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">ODBC 
              DATETIME</a></p></td>
          <td class="line"> <p>6</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1208</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">DB2 
              DATETIME</a></p></td>
          <td class="line"> <p>16</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1206</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">INFORMIX 
              DATETIME</a></p></td>
          <td class="line"> <p>24</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1205</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">C 
              DATETIME</a></p></td>
          <td class="line"> <p>4</p></td>
          <td class="line"> <p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1299</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">OMNIDEX 
              DATETIME</a></p></td>
          <td class="line"> <p>1 - 8</p></td>
          <td class="line"> <p>2 - 16 (optional, default 16)</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1900</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">BLOB</a></p></td>
          <td class="line"> <p># of bytes</p></td>
          <td class="line"> <p># of bytes</p></td>
        </tr>
        <tr> 
          <td class="line"> <p>1999</p></td>
          <td class="line"> <p><a href="#nclob"><img src="../images/arrow2.gif" width="10" height="10" border="0">OMNIDEX 
              BLOB</a></p></td>
          <td class="line"> <p># of bytes</p></td>
          <td class="line"> <p># of bytes</p></td>
        </tr>
      </table>
      <p class="line">&nbsp;</p>
      <h3><a name="back"></a>Backward Compatibility</h3>
      <p>Prior to Omnidex version 4.1, data type lengths were declared using the 
        length keyword followed by the length. This method was abandoned in favor 
        of the more common and intuitive approach used by many RDBMS. The old 
        method is still supported but no longer recommended.</p>
      <p>When using this style to declare data types, the length value is required 
        for all data types.</p>
      <p class="ex">DATATYPE datatype LENGTH n</p>
      <p><img src="../images/note.gif" width="12" height="15">Length values can 
        be different when using the old syntax. See <a href="#list">Data Types 
        Quick Reference</a> for a side-by-side comparison.</p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --><P align="right"><a href="#">Top</a> </P>
	  </td>
  </tr>
  <tr>
    <td width="175" class="bbar">
<p>&nbsp;</p></td>
    <td align="right" valign="middle" class="bbar"> <p class="banner">Omnidex 
        Version 4.1 Build 1 - E10.04 - Dynamic Information Systems Corporation 
        - Copyright &copy; 2004</p></td>
  </tr>
</table>
<div class="menu0" id="m1" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');"> 
  <a href="../index.htm">Home</a></div>      
<div class="menu0" id="m2" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');"> 
  <a href="../Omnidex%20Concepts/Omnidex%20Overview.htm">Omnidex</a></div>      
<div class="menu0" id="m3" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');"> 
  <a href="../Getting%20Started/Getting%20Started.htm">Getting Started </a></div>      
<div class="menu0" id="m4" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');"> 
  <a href="../Development/Development.htm">Development</a></div>      
<div class="menu0" id="m5" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');"> 
  <a href="../Utilities/Utilities.htm">Utilities</a></div>      
<div class="menu0" id="m6" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');"> 
  <a href="Appendix.htm">Appendix</a></div>
    <td>&nbsp;</td>
  </tr>
</table> 
<table id="s1" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');">
  <tr> 
    <td id="s11" class="menu1" onMouseOver="changeClass('menu0','s11');" onMouseOut="changeClass('menu1','s11');"><a href="../Whats%20New.htm">What's 
      New!</a></td>
  </tr>
  <tr> 
    <td id="s12" class="menu1" onMouseOver="changeClass('menu0','s12');" onMouseOut="changeClass('menu1','s12');"><a href="../Quick%20Links.htm">Quick 
      Links</a></td>
  </tr>
  <tr> 
    <td id="s13" class="menu1" onMouseOver="changeClass('menu0','s13');" onMouseOut="changeClass('menu1','s13');"><a href="../Contents.htm">Contents</a></td>
  </tr>
</table>
<table id="s2" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');">
  <tr> 
    <td id="s21" class="menu1" onMouseOver="changeClass('menu0','s21');" onMouseOut="changeClass('menu1','s21');"><a href="../Omnidex%20Concepts/Features/Features.htm">Features</a></td>
  </tr>
  <tr> 
    <td id="s22" class="menu1" onMouseOver="changeClass('menu0','s22');" onMouseOut="changeClass('menu1','s22');"><a href="../Omnidex%20Concepts/Indexing%20Strategies/Indexing%20Strategies.htm">Indexing 
      Strategies</a></td>
  </tr>
  <tr> 
    <td id="s23" class="menu1" onMouseOver="changeClass('menu0','s23');" onMouseOut="changeClass('menu1','s23');"><a href="../Omnidex%20Concepts/Indexing%20Options/Indexing%20Options.htm">Indexing 
      Options </a></td>
  </tr>
  <tr> 
    <td id="s24" class="menu1" onMouseOver="changeClass('menu0','s24');" onMouseOut="changeClass('menu1','s24');"><a href="../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Index 
      Maintenance </a></td>
  </tr>
  <tr> 
    <td id="s25" class="menu1" onMouseOver="changeClass('menu0','s25');" onMouseOut="changeClass('menu1','s25');"><a href="../Omnidex%20Concepts/Partitioning/Partitioning.htm">Optimization</a></td>
  </tr>
  <tr> 
    <td id="s26" class="menu1" onMouseOver="changeClass('menu0','s26');" onMouseOut="changeClass('menu1','s26');"><a href="../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Partitioning</a></td>
  </tr>
  <tr> 
    <td id="s27" class="menu1" onMouseOver="changeClass('menu0','s27');" onMouseOut="changeClass('menu1','s27');"><a href="../Omnidex%20Concepts/Text/Omnidex%20Text.htm">Omnidex Text</a></td>
  </tr>
</table>
<table id="s3" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');">
  <tr> 
    <td id="s31" class="menu1" onMouseOver="changeClass('menu0','s31');" onMouseOut="changeClass('menu1','s31');"><a href="../Getting%20Started/1%20-%20Installation%20and%20Setup.htm">Server 
      Setup Guides</a></td>
  </tr>
  <tr> 
    <td id="s32" class="menu1" onMouseOver="changeClass('menu0','s32');" onMouseOut="changeClass('menu1','s32');"><a href="../Getting%20Started/Omnidex%20Client/Windows%20Client.htm">Windows 
      Client</a></td>
  </tr>
  <tr> 
    <td id="s33" class="menu1" onMouseOver="changeClass('menu0','s33');" onMouseOut="changeClass('menu1','s33');"><a href="../Database%20Platforms/Supported%20Database%20Platforms.htm">Database 
      Platforms </a></td>
  </tr>
  <tr> 
    <td id="s34" class="menu1" onMouseOver="changeClass('menu0','s34');" onMouseOut="changeClass('menu1','s34');"><a href="../Environment%20Catalog/Environment%20Catalog.htm">Environment 
      Catalog</a> </td>
  </tr>
</table>
<table id="s4" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');">
  <tr> 
    <td id="s41" class="menu1" onMouseOver="changeClass('menu0','s41');" onMouseOut="changeClass('menu1','s41');"><a href="../SQL%20Reference/SQL%20Reference.htm">SQL 
      Reference</a> </td>
  </tr>
  <tr> 
    <td id="s42" class="menu1" onMouseOver="changeClass('menu0','s42');" onMouseOut="changeClass('menu1','s42');"><a href="../Development/ODBC/ODBC.htm">ODBC</a></td>
  </tr>
  <tr> 
    <td id="s43" class="menu1" onMouseOver="changeClass('menu0','s43');" onMouseOut="changeClass('menu1','s43');"><a href="../Development/JDBC/JDBC.htm">JDBC</a></td>
  </tr>
  <tr> 
    <td id="s44" class="menu1" onMouseOver="changeClass('menu0','s44');" onMouseOut="changeClass('menu1','s44');"><a href="../Development/OmniAccess%20API/OmniAccess%20API.htm">OmniAccess 
      API</a></td>
  </tr>
  <tr> 
    <td id="s45" class="menu1" onMouseOver="changeClass('menu0','s45');" onMouseOut="changeClass('menu1','s45');"><a href="../Development/Debugging/OMNIDEX_DEBUG.htm">Debugging</a></td>
  </tr>
</table>
<table id="s5" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');">
  <tr> 
    <td id="s51" class="menu1" onMouseOver="changeClass('menu0','s51');" onMouseOut="changeClass('menu1','s51');"><A href="../Utilities/DBINSTAL/DBINSTAL.htm">DBINSTAL</A></td>
  </tr>
  <tr> 
    <td id="s52" class="menu1" onMouseOver="changeClass('menu0','s52');" onMouseOut="changeClass('menu1','s52');"><a href="../Utilities/DSEDIT/DSEDIT.htm">DSEDIT</a></td>
  </tr>
  <tr> 
    <td id="s53" class="menu1" onMouseOver="changeClass('menu0','s53');" onMouseOut="changeClass('menu1','s53');"><a href="../Utilities/NSADMIN/NSADMIN.htm">NSADMIN</a></td>
  </tr>
  <tr> 
    <td id="s54" class="menu1" onMouseOver="changeClass('menu0','s54');" onMouseOut="changeClass('menu1','s54');"><a href="../Utilities/OACOMP/OACOMP.htm">OACOMP</a></td>
  </tr>
  <tr> 
    <td id="s55" class="menu1" onMouseOver="changeClass('menu0','s55');" onMouseOut="changeClass('menu1','s55');"><a href="../Utilities/OADECOMP/OADECOMP.htm">OADECOMP</a></td>
  </tr>
  <tr> 
    <td id="s56" class="menu1" onMouseOver="changeClass('menu0','s56');" onMouseOut="changeClass('menu1','s56');"><a href="../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a></td>
  </tr>
  <tr> 
    <td id="s57" class="menu1" onMouseOver="changeClass('menu0','s57');" onMouseOut="changeClass('menu1','s57');"><A href="../Utilities/ODXAIM/ODXAIM.htm">ODXAIM</A></td>
  </tr>
  <tr> 
    <td id="s58" class="menu1" onMouseOver="changeClass('menu0','s58');" onMouseOut="changeClass('menu1','s58');"><a href="../Utilities/ODXMAKE/ODXMAKE.htm">ODXMAKE</a></td>
  </tr>
  <tr> 
    <td id="s59" class="menu1" onMouseOver="changeClass('menu0','s59');" onMouseOut="changeClass('menu1','s59');"><a href="../Utilities/ODXNET/ODXNET.htm">ODXNET</a></td>
  </tr>
  <tr> 
    <td id="s510" class="menu1" onMouseOver="changeClass('menu0','s510');" onMouseOut="changeClass('menu1','s510');"><A href="../Utilities/ODXQUERY/ODXQUERY.htm">ODXQUERY</A></td>
  </tr>
  <tr> 
    <td id="s511" class="menu1" onMouseOver="changeClass('menu0','s511');" onMouseOut="changeClass('menu1','s511');"><a href="../Utilities/ODXSQL/ODXSQL.htm">ODXSQL</a></td>
  </tr>
  <tr> 
    <td id="s512" class="menu1" onMouseOver="changeClass('menu0','s512');" onMouseOut="changeClass('menu1','s512');"><a href="../Utilities/REGMAINT/REGMAINT.htm">REGMAINT</a></td>
  </tr>
  <tr> 
    <td id="s513" class="menu1" onMouseOver="changeClass('menu0','s513');" onMouseOut="changeClass('menu1','s513');"><A href="../Utilities/REGTEST/REGTEST.htm">REGTEST</A></td>
  </tr>
  <tr> 
    <td id="s514" class="menu1" onMouseOver="changeClass('menu0','s514');" onMouseOut="changeClass('menu1','s514');"><a href="../Utilities/SNOWGEN/SNOWGEN.htm">SNOWGEN</a></td>
  </tr>
  <tr> 
    <td id="s515" class="menu1" onMouseOver="changeClass('menu0','s515');" onMouseOut="changeClass('menu1','s515');"><a href="../Utilities/SYSINFO/SYSINFO.htm">SYSINFO</a></td>
  </tr>
  <tr> 
    <td id="s516" class="menu1" onMouseOver="changeClass('menu0','s516');" onMouseOut="changeClass('menu1','s516');"><a href="../Utilities/VERSIONS/VERSIONS.htm">VERSIONS</a></td>
  </tr>
  <tr> 
    <td id="s517" class="menu1" onMouseOver="changeClass('menu0','s517');" onMouseOut="changeClass('menu1','s517');"><a href="../Utilities/VIEWGEN/VIEWGEN.htm">VIEWGEN</a></td>
  </tr>
</table>
<table id="s6" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');">
  <tr> 
    <td id="s61" class="menu1" onMouseOver="changeClass('menu0','s61');" onMouseOut="changeClass('menu1','s61');"><a href="Cardinality.htm">Cardinality</a></td>
  </tr>
  <tr> 
    <td id="s62" class="menu1" onMouseOver="changeClass('menu0','s62');" onMouseOut="changeClass('menu1','s62');"><a href="Date%20Formats.htm">Date 
      Formats </a></td>
  </tr>
  <tr> 
    <td id="s63" class="menu1" onMouseOver="changeClass('menu0','s63');" onMouseOut="changeClass('menu1','s63');"><a href="Environment%20Variables.htm">Environment 
      Variables </a></td>
  </tr>
  <tr> 
    <td id="s64" class="menu1" onMouseOver="changeClass('menu0','s64');" onMouseOut="changeClass('menu1','s64');"><a href="File%20Name%20Handling.htm">File 
      Name Handling</a></td>
  </tr>
  <tr> 
    <td id="s65" class="menu1" onMouseOver="changeClass('menu0','s65');" onMouseOut="changeClass('menu1','s65');"><a href="Glossary%20A.htm">Glossary</a></td>
  </tr>
  <tr> 
    <td id="s66" class="menu1" onMouseOver="changeClass('menu0','s66');" onMouseOut="changeClass('menu1','s66');"><a href="Null.htm">Null</a></td>
  </tr>
  <tr> 
    <td id="s67" class="menu1" onMouseOver="changeClass('menu0','s67');" onMouseOut="changeClass('menu1','s67');"><a href="OAGLOBAL.htm">OAGLOBAL</a></td>
  </tr>
  <tr> 
    <td id="s68" class="menu1" onMouseOver="changeClass('menu0','s68');" onMouseOut="changeClass('menu1','s68');"><a href="Operating%20Limits.htm">Operating 
      Limits</a></td>
  </tr>
  <tr> 
    <td id="s69" class="menu1" onMouseOver="changeClass('menu0','s69');" onMouseOut="changeClass('menu1','s69');"><a href="Provided%20Managed%20Synonym%20Lists.htm">Managed 
      Synonym Lists</a></td>
  </tr>
  <tr> 
    <td id="s70" class="menu1" onMouseOver="changeClass('menu0','s70');" onMouseOut="changeClass('menu1','s70');"><a href="Reserved%20Words.htm">Reserved 
      Words</a></td>
  </tr>
  <tr> 
    <td id="s71" class="menu1" onMouseOver="changeClass('menu0','s71');" onMouseOut="changeClass('menu1','s71');"><a href="Supported%20Datatypes.htm">Supported 
      Data Types</a></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
<!-- InstanceEnd --></html>
