Kbase P6075: Is It Possible To Define A VARCHAR Column In SQL92 As Case-Insensitive ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/10/2006 |
|
Status: Verified
GOAL:
Is it possible to define a VARCHAR column in SQL92 as case-insensitive ?
FIX:
For OpenEdge 10.0B or earlier:
This is not possible, the SQL92 standard states that all columns be case-sensitive.
Use the LCASE or UCASE functions to implement a case-insensitive comparison.
For OpenEdge 10.1A or later:
An extension to the SQL92 standard has been added.
You can now create a case-insensitive column by specifying "COLLATE case_insensitive" in the column definition.
The ALTER TABLE statement also allows you to change the case-sensitive state of a column.