Kbase P160434: Error 7516 when using clause "collate case_insensitive" in ALTER TABLE statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/19/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 7516 when using clause "collate case_insensitive" in ALTER TABLE statement
ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Invalid collation name specified (7516)
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.2B
OpenEdge Category: SQL
Running the query: ALTER TABLE <table_name> ADD COLUMN <column_name> <data_type> COLLATE case_insensitive
CAUSE:
This is expected behavior. In OE 10.2B the syntax for case sensitivity in COLLATE clause was changed
FIX:
Use the following syntax:
Syntax for case insensitive: COLLATE I or COLLATE _I, or COLLATE BASIC_I
Syntax for case sensitive: COLLATE S or COLLATE _S, or COLLATE BASIC_S