Macromedia ColdFusion MX 6.1 and MX 7 offer two data source types to connect to Microsoft Access databases. They are labeled "Microsoft Access" and "Microsoft Access with Unicode." The Microsoft Access with Unicode type uses the jadoZoom JDBC driver. The jadoZoom driver is often used as an alternative to the standard "Microsoft Access" data source type for connecting to Microsoft Access.
There are several issues to be aware of when using the Microsoft Access with Unicode driver:
- Inserts and updates fail with the error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." This occurs because the data fails to truncate to the maximum column size.
- Booleans must be specified as True or False, whereas 1 or 0 can be used with the Microsoft Access data source type.
- Default values are not automatically inserted to columns.