With more and more traditional c-tree users leveraging the power of c-treeACE SQL, FairCom has labored to keep this transition as easy as possible. While we strive for the utmost in compatibility, we occasionally find areas where it is possible to encounter unexpected situations. The c-tree ODBC and c-treeACE SQL ODBC drivers are both fully standards compliant, however, subtle differences do exist. We have summarized these differences here.
Another option is to use the SQL_OPTION DB_CASE_INSENSITIVE keyword before creating the template database and the c-treeACE SQL databases.