Creating a Transact-SQL Compatible Database from Sybase Central

Create a Transact-SQL compatible database with case sensitivity settings that emulate Adaptive Server Enterprise.

  1. In the Create Database wizard, access the Specify a Collation Sequence page.
  2. Set Case Sensitivity for String comparisons to ON. This emulates Adaptive Server Enterprise.
  3. Set Case Sensitivity for Passwords to ON.

These case sensitivity settings emulate Adaptive Server Enterprise.

Parent topic: Data Definition Language