how do you convert binary into char

[aks2trip]

how do you convert binary into character??
i am trying to convert a BLOB field into text and trying to extract the information put into the blob field.
i had read up suggestions which said to write a sql expression using cast statement but it does not work . it gives me an error.
how do i go about converting this BLOB( graphic field) into a text field? someone plz help

 

[synapsevampire]

What version of CR/Database are you using? What is the actual data type in the database?

What did you use as the cast statement that failed?

In SQL Server you cannot cast a Image type to a varchar, if you're storing text in an image type, place your dba in a large vat of sulfuric acid, adding nitric acid and a touch of glycerin, and gently nudge it out the nearest window.

-k

 

[aks2trip]

I am using oracle 8 version ODBC (VISUAL)
crystal reports version 8.5
the field type in the database is supp to be LONGVAR
the statement i used was
CAST ( CAST ( PART_BINARY."BITS" AS VARBINARY(254))) AS VARCHAR(254)