Icon View Incident Report

Minor Minor
Reported By: Ole Willy Tuv
Reported On: 3/23/2007
For: Version 1.01 Build 1
# 2280 COLLATE Clause is Case-Sensitive When it Should be Case-Insensitive

The following SQL produces the error:

ElevateDB Error #700 An error was found in the statement at line 5 and column 28 (ElevateDB Error #401 The collation enu_ci does not exist)

It seems like the collation identifier is partly case-sensitive, collate enu_CI does work.

create table test
 col1 integer,
 col2 varchar(10) collate enu,
 col3 varchar(10) collate enu_ci

Resolution Resolution
Fixed Problem on 3/24/2007 in version 1.02 build 1

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