Kbase P114196: SQL queries that use a trailing wildcard fail with ICU-** collation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
OpenEdge 10.0B
SYMPTOM(s):
10.0B03
Querying database via SQL
SQL query contains "LIKE" statement with a trailing wildcard, for example:
SELECT name FROM pub.customer WHERE name LIKE 'L%'
No results are returned
Same query within 4GL returns a result set
SQL query returns a result set when there is an exact match, for example:
SELECT name FROM pub.customer WHERE name LIKE 'Lift Tours'
SQL query returns a result set when the wildcard precedes the search criteria, for example:
SELECT name FROM pub.customer WHERE name LIKE '%L'
Database codepage is UTF-8
Database collation is ICU-da
SQL query returns a result set when database collation is Basic
Same problem occurs when a different ICU-** collation table is used
CAUSE:
Bug# 20050629-007
FIX:
Upgrade to OpenEdge 10.0B05
Upgrade to OpenEdge 10.1A01 or later
Upgrade to OpenEdge 10.1B