Image data type

[tomchris2004]

Hi
I am wondering, is there any image data type in teradata.If so whats the data type and how u can store that in a table.If any one know pls let me know.If anybody knows any example that will be great.


Thanks
Chris

 

[tdatgod]

Hi,
The answer to your direct question is NO. There is no Image Data Type in Teradata. Maybe when we support User defined types there will be.

However, Teradata has an application available on Windows as part of the Teradata client called.....

BLOB SERVER

This allow you to store and retrieve BLOBS ( Binary Large Objects ) into Teradata by breaking the BLOB into 30K chunks and storing each Chunk as a row in a table.


Then the BLOBSERVER can retrieve the BLOB back ( one row at time and write them into a single contiguous file) to be viewed.


You could always write your own application to store and retrieve the information like the BLOBSEREVR does.

The theory behind the Blob server is explained in the CLI V2 Developers Kit for Windows which you can down load from from

http://www.info.ncr.com/sd/sd-1.cfm?page=twotc

click on Call-Level interface (CLI)

and pick the

Teradata CLI Version 2 Developer's Kit for Windows

for your particular version of Teradata.


If you want you can make a reference between your BASE tables and the BLOB table by using the name of the image in your base table, but I think the user will have to go use the BLOB server to display the image, unless again you write your application to bridge the gap.



---