Text File Data Types

CHAR

SQL_VARCHAR

DATETIME

SQL_TIMESTAMP

FLOAT

SQL_DOUBLE

INTEGER

SQL_INTEGER

LONGCHAR

SQL_LONGVARCHAR

CHAR

Creating a CHAR column of zero or unspecified length actually returns a 255-bit column.

In delimited files, a CHAR column may or may not have double quotation mark delimiters at the beginning and the end; in fixed-length files, double quotation marks are not used as delimiters.

DATETIME

MM-DD-YY (for example, 01-17-92)

MMM-DD-YY (for example, Jan-17-92)

DD-MMM-YY (for example, 17-Jan-92)

YYYY-MM-DD (for example, 1992-01-17)

YYYY-MMM-DD (for example, 1992-Jan-17)

Mixed date separators are not allowed within a table.

The Text ISAM formats a DATETIME field in the United States or European format, depending upon the International setting in the Windows Control Panel.

FLOAT

The maximum width includes the sign and decimal point. In Schema.ini, the width is denoted as follows:

14.083 is FLOAT Width 6

-14.083 is FLOAT Width 7

+14.083 is FLOAT Width 7

14083. is FLOAT Width 6

ODBC always returns 8 for FLOAT columns.

FLOAT columns can also be in scientific notation, for example:

-3.04E+2 is Float Width 8

25E4 is Float Width 4

Note   Decimal and scientific notation cannot be mixed in a column.

NULL values are represented by a blank padded string in fixed-length files, and are omitted in delimited files.

Float data can be padded with leading blanks.

INTEGER

Valid values for INTEGER columns are 32767 to -32766.

In Schema.ini, the width is denoted as follows:

14083 is INTEGER Width 5

0 is INTEGER Width 1

ODBC always returns 4 for INTEGER columns.

The maximum width includes a sign. The maximum width of an INTEGER column is 11, although the width can be greater due to blanks that are allowed in fixed-format tables.

LONGCHAR

The theoretical limit on the width of a LONGCHAR column in either a fixed-length or delimited table is 65500K. The Text ISAM is more likely to provide reliable support up to about 32K.