View Incident Report

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap