Posted by phil2phil on 03/12/07 16:40

I think i found it, the stored proc doing the actual insert into the
table, was set to @ESSAYTEXT varchar(200) for that column, we decided
to restrict it to 2000 chars, so changing it to @ESSAYTEXT
varchar(2000), hopefully that's fix it, the varchar(200) explains the
max(len issue as well.

On Mar 12, 12:26 pm, "phil2phil" <philtwop...@yahoo.com> wrote:
> Hi,
> I've tried both Sql sever 2000 QA and Sql server 2005 Management
> Studio. For QA i set the Results Max chars to 8192 and in Management
> studio i set the max chars per column for Text Retults to 8192 and for
> Grid to Non XML 65535, but it's still not returning the full, and each
> max length is always 200.
>
> On Mar 12, 12:11 pm, "Greg D. Moore \(Strider\)"
>
> <mooregr_deletet...@greenms.com> wrote:
> > "phil2phil" <philtwop...@yahoo.com> wrote in message
>
> >news:1173714656.510142.22770@v33g2000cwv.googlegroups.com...
>
> > > hi,
> > > i have a column of type ntext in the db, we're using that to allow
> > > users to store essays they can enter. problem is when i'm running a
> > > select on the ntext column, data seems to be getting cut off, isn't
> > > ntext suppose to hold a lot of data, we wanted to allow them in a min
> > > of 1500 chars, while everytime i do a
> > > select len(max (convert(nvarchar(2000), essaytext)))
>
> > > just to see the max we one had it's always 200.
>
> > > Thanks.
>
> > What tool are you using for this? If it's QA, you can adjust what it returns
> > via a setting.
>
> > --
> > Greg Moore
> > SQL Server DBA Consulting
> > Email: sql (at) greenms.com http://www.greenms.com

[Back to original message]