![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 06 Oct 2009 @ 08:52:36 GMT
Subj: | | Re: Storing the complete file in Teradata tables |
|
From: | | Victor Sokovin |
| I got a strange requirement where I have text files having about 1000 charecters. I need to store the complete content of this file in a
teradata table. | |
| For example, if I have two files A & B, with 1000 chars each, content of the file A should go into one cell and the content of file B into
another | |
| I am just wondering how I can define the column . | |
The requirement is not that strange these days. Databases are used for storing such data as text, images, audio, video etc.
With text files of small size such as 1 kB you might be able to store them as VARCHAR but check whether your data loaders will support that.
Some may forget the end-of-line characters or will perform conversion to another character set but in general VARCHAR is the easiest format to
work with.
You may also want to check out the options offered by BLOB formats. There is a good introductory thread on them in the archives:
www.teradataforum.com/teradata/20050110_233007.htm
Victor
| |