CONFIG.INI, as shipped, contains two database type definition sections. One is used when the Points table is created using MS-Access and the other when MS SQL Server is the database. These are colon-delimited tables that map the database's native data types to the nearest VTS equivalent. Each table must begin with a […] header that is used to label the database brand to which the table applies.
The table includes 9 fields, structured is as follows:
Key Field A unique identifier for each row.
Base Type The equivalent field type as defined by the target database
VTS Type The data type stored by VTS, from the enumeration below.
0 = Boolean, the value is recorded as 1 or 0.
1 = Short Integer, the value is between -32768 and 32767.
2 = Long integer, the value is between -2147483648 and 2147483647.
3 = Double, the value is stored as a double-precision IEEE float.
4 = Text, the value is stored as a string.
5 = Binary, the value stored as an opaque buffer.
Numeric Boolean: 1 if the field type is numeric, 0 if it is character data.
Pre-Delimiter Indicates the delimiter to be used at the beginning of text fields
Post-Delimiter Indicates the delimiter to be used at the end of text fields
Set Size If the type has a variable width and it is desirable that this be fixed, set the fixed value here. Otherwise enter a dash (-) or a space.
Max Size If the type has a variable width, this is the maximum allowed number of bytes. Fixed or width-less types must use zero, a dash (-) or a space.
Overflow If the type has a maximum width then use this type in the event that the width is exceeded. This should only be used by types using the Max Size field. Other types must enter a dash (-) or leave blank.
Example for MS Access:
[SQL_Access_Types]
SQL_LONGUNICODE = LONGTEXT :4:0:':': : :
SQL_BIT = BIT :0:1:':': : :
SQL_TINYINT = BYTE :1:1:':': : :
SQL_BIGINT = LONG :2:1:':': : :
SQL_LONGVARBINARY = LONGBINARY :5:1:':': : :
SQL_VARBINARY = VARBINARY :5:1:':': :255:LONGBINARY
…
Example for MS SQL Server:
[SQL_MSServer_Types]
SQL_LONGUNICODE = NTEXT :4:0:':': : :
SQL_BIT = BIT :0:1:':': : :
SQL_TINYINT = TINYINT :1:1:':': : :
SQL_BIGINT = BIGINT :2:1:':': : :
SQL_LONGVARBINARY = IMAGE :5:1: : : : :
SQL_VARBINARY = VARBINARY:5:1: : : :4000:IMAGE
…