View Incident Report

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

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

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

Products Affected

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap