Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 8/19/2010
For: Version 2.03 Build 20
# 3283 CASTing a BLOB to a VARCHAR Causes First 3 Characters to Be Truncated

The first SQL statement below gives:


The second SQL statement below gives:


The latter is right. The _LatestCV column is a BLOB.

select substr(cast(_Latestcv as varchar(100)),1,10)
from contacts where _latestcvtype = '.rtf'

select substr(cast(_Latestcv as clob),1,10)
from contacts where _latestcvtype = '.rtf'

Comments Comments and Workarounds
The workaround is to CAST the BLOB to a CLOB, and then to a VARCHAR.

Resolution Resolution
Fixed Problem on 8/21/2010 in version 2.03 build 21

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 LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial