SQL 6.5 datatype "text"?

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I canīt upload data from a .txt file via bcp, all the columns are complete but the text column which is a datatype 'text' is truncated, it only holds 255 bytes, what should I do to increase de text size?

-- Anonymous, November 01, 2001



The data may actually be importing but you can only see the first 256 characters in ISQL/w or the Query Analyzer. Test it by bcp'ing out the data and looking at the text column data.

Hope this helps,


-- Anonymous, November 02, 2001

Moderation questions? read the FAQ