View Incident Report

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:

f1\ansi\an

The second SQL statement below gives:

{\rtf1\ans

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 and Workarounds

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

Resolution

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap