This section describes choices you must make when creating or rebuilding a database.
Here are the basic steps you need to take to create a Transact-SQL compatible database. The remainder of the section describes which options you need to set.
Creating a Transact-SQL compatible database from
Sybase Central
In the Create Database wizard, access the Specify a Collation Sequence page.
Set Case Sensitivity for String comparisons to ON. This emulates Adaptive Server Enterprise.
Set Case Sensitivity for Passwords to ON.
These case sensitivity settings emulate Adaptive Server Enterprise.
Creating a Transact-SQL compatible database using
the CREATE DATABASE statement
Type the following statement, for example, in Interactive SQL:
CREATE DATABASE 'db-name.db'
CASE RESPECT BLANK PADDING ON
