📄 supporteddatatypes.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
📖 第 1 页 / 共 2 页
字号:
12 下一页
<html>
<head>
   <title>Field Data Types</title>
</head>

<!--#include virtual="/inc/header.php"-->


<table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="#FFFFFF">
  <tr>
    <td align="left">
      
<span style="font-family:Helvetica,Arial; font-size:12pt; color:#000000"><b>Field Data Types
<br>
</b></span>
    </td>
    <td align="right">
     <font face="Arial" size="2">
     <a href="maximumcapacityspecification.htm">Previous</a>&nbsp;
     <a href="overview.htm">Top</a>&nbsp;
     <a href="errorcodes.htm">Next</a>
     </font>
    </td>
  </tr>
</table>
<br><br>



<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#010100">
<br>
Field data types supported by Absolute Database are listed below:
<br>

<br>
<table border="0" cellpadding="1"><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:8pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:8pt; color:#010100"><b><u>Data Type</u></b></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:8pt; color:#000000"><b><u>TFieldType</u></b><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:8pt; color:#000000"><b><u>AdvFieldType</u></b><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:8pt; color:#000000"><b><u>SQL Data Type</u></b><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:8pt; color:#000000"><span style="font-family:Helvetica,Arial; font-size:8pt; color:#010100"><b><u>Description</u></b></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span></span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">AutoInc
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftAutoinc
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftAutoinc
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">AUTOINC
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Auto incremental 32-bit unsigned integer.
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">BLOB
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftBlob
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftBlob
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">BLOB
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Binary Large Object - variable length binary data 
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Bytes ( length )
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftBytes
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftBytes
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">BYTES
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Fixed length binary data 
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Currency
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftCurrency
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftCurrency
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">CURRENCY, MONEY
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Money value.
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Date
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftDate
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftDate
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">DATE
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Date value.
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">DateTime
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftDateTime
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftDateTime
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">DATETIME
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">DateTime value.
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Extended
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftExtended
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftExtended
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">EXTENDED
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Extended floating point number.
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Float
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftFloat
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftDouble
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">FLOAT
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Floating point number
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">FmtMemo
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftFmtMemo
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftFormattedMemo
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">FORMATTEDMEMO
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Formatted memo - variable length string in RTF format
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Graphic
<br>
</span></td><td align="left" valign="top" width="76">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">ftGraphic
<br>
</span></td><td align="left" valign="top" width="115">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">aftGraphic
<br>
</span></td><td align="left" valign="top" width="125">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">GRAPHIC
<br>
</span></td><td align="left" valign="top" width="164">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Binary data for storing pictures
<br>
</span></td></tr><tr><td align="left" valign="top" width="91">
<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">GUID
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -