SQL adaptation guide For Sybase ASE 15.5+ / Data dictionary |
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'
When you create a Sybase ASE database with dbinit, you can use the -c option to make the database case-sensitive.