The default setting for some options differs from the Adaptive Server Enterprise default setting. To ensure compatible behavior, you should explicitly set the options.
When a connection is made using the Open Client or JDBC interfaces, some option settings are explicitly set for the current connection to be compatible with Adaptive Server Enterprise.
| Option | ASE-Compatible Setting |
|---|---|
| ALLOW_NULLS_BY_DEFAULT | OFF |
| ANSINULL | OFF |
| CHAINED | OFF |
| CONTINUE_AFTER_RAISERROR | ON |
| DATE_FORMAT | YYYY-MM-DD |
| DATE_ORDER | MDY |
| ESCAPE_CHARACTER | OFF |
| ISOLATION_LEVEL | 1 |
| ON_TSQL_ERROR | CONDITIONAL |
| QUOTED_IDENTIFIER | OFF |
| TIME_FORMAT | HH:NN:SS.SSS |
| TIMESTAMP_FORMAT | YYYY-MM-DD HH:NN:SS.SSS |
| TSQL_VARIABLES | OFF |