Case sensitivity

In Informix^®, database object names like table and column names are not case sensitive:

CREATE TABLE Customer ( Custno INTEGER, ... )
SELECT CustNo FROM cuSTomer ...

In Sybase ASE, database object names and character data are case-insensitive by default:

CREATE TABLE Customer ( Custno INTEGER, CustName CHAR(20) )
INSERT INTO CUSTOMER VALUES ( 1, 'TECHNOSOFT' )
SELECT CustNo FROM cuSTomer WHERE custname = 'techNOSoft'

Solution

When you create a Sybase ASE database with dbinit, you can use the -c option to make the database case-sensitive.