Progress
Version 9
Product Update Bulletin


CREATE TABLE Statement Supports Case Sensitive Naming

You can use the CREATE TABLE statement to define the case sensitivity of a particular character column. By default, columns defined in SQL are case sensitive.

The following CREATE TABLE statement illustrates how you can define a character column’s sensitivity:

CREATE TABLE Customer (name VARCHAR (100) COLLATE basic_S, region VARCHAR 
(100) COLLATE basic_I, address VARCHAR (100)); 

This statement produces a table with three character columns. The first column is case sensitive because the last character of the collation is S or s. The second column is insensitive because the last character is I or i. The third column is case sensitive because, in the absence of an explicit COLLATE modifier, the column assumes the case sensitive default.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095