[RESOLVED] SQL Server Data Length Problem

[obrienkev]

Hi all,

I want to enter the below data into a database...

insert into price_list(price_list, price_list_note) values('MDC2 Close','This price list represents all close prices sent electronically by the vendor (FT InteractiveData ("IC")) for all US Debt securities. IDC data can be looked up through the website or through a Geneva price query');

However the price_list_note data gets truncated. Only first half gets inserted into the database.

Why is this?

I'm using Data Type Varchar with Length=8000
Also tried text(16)

Any ideas?? Thanks.

[obrienkev]

This seems to work...

set data type to text

sp_tableoption N'MyTable', 'text in row', 'ON'

sp_tableoption N'MyTable', 'text in row', '7000'