Long varchar or text data type???
Posted on 2003-03-22
I created a table that consists of several columns and data field. I need to have a column that has at least 2000 chars to be stored in it. I tried the long varchar data type but after several data entry, record truncation happens. After this, I changed the data type to text. Again, record truncation happened.
Why is this happening and what caused it? How will I able to fix this problem? One last thing, I'm just wondering if this is possible, can I use Rich Text to store data into this column??? If yes, how can I do that?