Icon View Incident Report

Serious Serious
Reported By: Robin Joseph
Reported On: 2/11/2008
For: Version 1.07 Build 3
# 2548 Casting a CLOB Column to Text Using .AsString with .NET Data Provider Returns Invalid Data

I am attempting to cast a CLOB column in a table to a VarChar using the following query.

When I display the column in a console window or a textbox as .GetString() or .AsString() the data is displayed as Unicode Hex characters rather than text, eg '43-00-4C-00-4F-00-42-00' rather than 'CLOB'.

Select CAST (Col1 as VarChar(500)) from Table1

Comments Comments
ElevateDB was using the wrong .NET framework method call to perform the conversion and was getting back the byte representation rather than the actual text.

Resolution Resolution
Fixed Problem on 2/11/2008 in version 1.08 build 1

Products Affected Products Affected
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial