text datatype

xkliburi · #1 (**permalink**) 05-21-03, 05:08

Hi. I need to use a table with a TEXT column but i don't now how to insert values.
Thanks.

pprince · #2 (**permalink**) 05-21-03, 05:39

Quote:

Originally posted by xkliburi
Hi. I need to use a table with a TEXT column but i don't now how to insert values.
Thanks.

I think you have to use the LOTOFILE function to move the data into a file then you load the text column with the LOAD function.
INSERTwill not work with text data over 256 chars...again I think.