Converting Image fields to char - How do you do it?????? 
Author Message
 Converting Image fields to char - How do you do it??????

We recently purchased some software that stores its data in Sybase.  We
were asked by the user community to periodically dump the data so they
could use it in other systems.  We developed stored procedures that uses
cursors  to process the data because the data structure is more
hierarchical than relational.  Okay to this point, piece of cake.  

As we were writing the procedures we noticed that they were using an image
field to store text.  But how the heck do you convert an image field to
character.  Using readtext we only see the hex not any character data.
Some of the text in this column is up to 1000 bytes long.  

We placed a call to their developers to ask how their software could
convert the data from image to text but all they would say was that it was
a 3GL function that converted the data.

No matter what string function I use all I can see is hex.  If any of you
have experience in this kind of conversion or know of anyway to convert
this data out to character fields please let me know.  Thanks in
advance........
Tom Baker
Corporate Database Administrator (Sybase System 10)
Harris Publishing

The definition of Insanity is:
  "Doing the same thing over and over and expecting different results."



Tue, 07 Jul 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ADO thinks DBMS is done, but DBMS ain't done

2. Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file

3. Caché from InterSystems - doing wh at other MV vendors should be doing

4. Image Database with VB..can it be done?

5. Info on computers doing (facial) image manipulation

6. Converting 2 char for month and year fields to single date field

7. SQL 7, DTS converting from a char field with a numeric value to a money field

8. Converting TEXT field to CHAR(5000) field

9. float fields doing me crazy

10. Retrieving ID field when doing an INSERT

11. Doing Join, how to reference common fields?

12. Problems with doing a select on text field in SQL Server


 
Powered by phpBB® Forum Software