Case sensitivity

Informix®

With Informix, database object names like table and column names are not case sensitive:

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

SAP ASE

With SAP® 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 SAP ASE database with dbinit, you can use the -c option to make the database case-sensitive.