Icon View Incident Report

Serious Serious
Reported By: Rolf Frei
Reported On: 7/17/2000
For: Version 2.03 Build 1
# 599 SQL UPPER and LOWER Functions and LIKE Operator Are Not Working Properly With ANSI Characters

The SQL and filtering UPPER and LOWER functions are stripping special ANSI accent characters and the SQL and filtering LIKE operator is not taking into account character comparisons properly for ANSI characters with special accents.

Select * from parts where Upper(Description) like '%KÜGEL%'

Resolution Resolution
Fixed Problem on 7/18/2000 in version 2.04 build 1