Reported By: Robin Joseph Reported On: 2/11/2008 For: Version 1.07 Build 3
# 2548Casting 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
CommentsElevateDB was using the wrong .NET framework method call to perform the conversion and was getting back the byte representation rather than the actual text.
ResolutionFixed Problem on 2/11/2008 in version 1.08 build 1
Products AffectedElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial