Icon View Incident Report

Serious Serious
Reported By: Dan Rootham
Reported On: 1/2/2008
For: Version 1.07 Build 1
# 2517 UPPER and LOWER SQL Functions Not Working Properly with Unicode Versions

Given this list:

begießen
Bonito
Fasanenbraten
gebratene Zucchini

I would expect the following SQL to return the same list in uppercase:

BEGIESSEN
BONITO
FASANENBRATEN
GEBRATENE ZUCCHINI

But what is actually returned is as follows:

Bauernhof
Drache
marinierter Aa
vatermörderisch

The result set differs, it is not in upper case, and the third term ('marinierter Aal') has been truncated at the final character.

SELECT UPPER(Term) AS UpperCase_Term FROM Dict_Deu



Comments Comments
The issue was with the internal calls to LCMapStringW for the Upper and Lower functionality.


Resolution Resolution
Fixed Problem on 1/3/2008 in version 1.07 build 2


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image