Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2005 @ 14:08:11 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: How can retrieve BMP/JPG/GIF thru SQL Assistant?
From:   Coffing Christopher L

  How can i retrieve BMP/JPG/GIF image data thru SQL Assistant? I am looking ur mail.  

In order to retrieve the BLOB, you will need an application to recontruct it back into an image. SQL Assistant will allow you to select the BLOB but will not bring it back as an image. You will only see the data as a series of hex characters.

If the file is a word doc or something like that, you will still need an application that can read that particular filetype.

BLOBs are new to the Teradata world but you should be able to access the information like you would with an Oracle or SQL Server solution. The BLOBs are stored in the database but you still need the application to reconstruct them into something useful.

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead DBA Operations & Support
Teradata Certified Master

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023