ODBC and JDBC Guide

Chapter 7
Reference information
ODBC Catalog functions
The ODBC client driver supports the following Catalog functions:
1 SQLTables—catalog information is stored and reported as single part names (table name only)
1 SQLColumns
1 SQLColumnPrivileges
1 SQLDescribeCol
1 SQLGetTypeInfo
JDBC DatabaseMetaData methods
The JDBC client driver supports the following DatabaseMetaData methods:
Mapping FileMaker fields to ODBC data types
This table illustrates how FileMaker field types map to the standard ODBC data types.
1 getColumns
1 getColumnPrivileges
1 getMetaData
1 getTypeInfo
1 getTables
1 getTableTypes
1 getVersionColumns
FileMaker field type Converts to ODBC data type About the data type
text SQL_VARCHAR The maximum column length of text is 1 million characters,
unless you specify a smaller Maximum number of
characters for the text field in FileMaker. FileMaker returns
empty strings as NULL.
number SQL_DOUBLE The FileMaker number field type can contain positive or
negatives values as small as 10
-308
, and as large as 10
+308
,
with up to 15 significant digits.
date SQL_DATE
time SQL_TIME The FileMaker time field type can contain the time of day or
a time interval. A time interval is returned as a time of day,
unless it is less than 0 or greater than 24 hours (both return
a value of 0).
timestamp SQL_TIMESTAMP
container (BLOB) SQL_LONGVARBINARY You can retrieve binary data, file reference information, or
data of a specific file type from a container field.
Within a SELECT statement, use the CAST() function to
retrieve file reference information, and use the GetAs()
function to retrieve data of a specific file type.
calculation The result is mapped to the corresponding ODBC data type.