Kbase P63396: Is SQL-92 query case-insensitive or case-sensitive?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Is SQL-92 query case-insensitive on SQL-92 table?
GOAL:
Is SQL-92 query case-insensitive on 4GL table?
FACT(s) (Environment):
Progress 9.x
FIX:
1) No. If you create an SQL-92 table, all columns are case-sensitive. In order to implement a case-insensitive comparison, you have to use UCASE/LCASE functions in your select statement (please note solution P59712 on performance effect).
2) Yes. If you create a 4GL table, all columns are case-insensitive (unless explicitly marked as case-sensitive). The SQL-92 engine has the ability to query case-insensitive columns properly. For example, "select name from customer where name = 'LIFT LINE SKIING'" returns "Lift Line Skiing" on Sports database.
Please note that if you don't create a proper index on 4GL side and SQL-92 is forced to create a dynamic index to do a join, your query becomes case-sensitive.