From the LabVIEW Database Connectivity User Manual
Because of the wide range of databases with which the Database Connectivity Toolkit works, some portability issues remain. Consider the following issues when choosing your database system:
- Some database systems, particularly the flat-file databases such as dBase, do not support floating-point numbers. In cases where floating-point numbers are not supported, the toolkit converts floating-point numbers to the nearest equivalent, usually binary-coded decimal (BCD), before storing them in the database. Very large or very small floating-point numbers can pass the upper or lower limits of the precision available for a BCD value.
- The Microsoft ODBC driver for Oracle and the Microsoft OLE DB Provider for Oracle do not support BLOB (binary) data types. You cannot use Oracle with the Database Connectivity Toolkit for binary data with these drivers. Instead, use the OLE DB Provider and ODBC driver that Oracle provides. Refer to the Oracle Web site at www.oracle.com for more information about the OLE DB Provider and the ODBC driver that Oracle provides.
- Restrictions on column names vary among database systems. For maximum portability, limit column names to ten uppercase characters without spaces. You might be able to access longer column, or field, names or names that contain spaces by enclosing the name in double quotes.
- Some database systems do not support date, time, or date and time data types.