First Class Access to Database-Specific Features

Just because AnyDAC provides access to different back-end databases, that does not mean you need to give up using the powerful and advanced features that make these databases unique.

Here is a list of some of the RDBMS-specific features that are actively supported by AnyDAC:

MSSQL:

• OS authentication (SSPI).
• SQL_VARIANT data type.
• NCHAR, NVARCHAR data types.
• CHAR(MAX), VARCHAR(MAX) data types.
• UNIQUEIDENTIFIER (GUID) data type.
• IDENTITY columns.
• PRINT / RAISERROR clauses.
• Client side / server side cursor types.
• Batch commands with multiple result sets.

Oracle:

• Login as SYSDBA, SYSOPER or by using OS authentication.
• Password expiration.
• BLOB, CLOB, BFILE data types.
• TIMESTAMP data type.
• UCS2, UTF8, etc character encodings.
• Full support for Oracle high precision numbers up to 38 digits.
• RETURNING clause.
• SELECT FOR UPDATE clause.
• SELECT CURSOR (…) clause.
• REF CURSOR.
• PL/SQL packages.
• Sequences.
• DBMS_OUTPUT.

MySQL:

• ENUM / SET data types.
• UCS2, UTF8, etc character encodings.
• AUTO_INCREMENT columns.
• Full support for MySQL 5 stored procedures.
• Batch commands with multiple result sets.