Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Oct 2009 @ 08:52:36 GMT

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

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:



  <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