"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23lXbFEttEHA.820@TK2MSFTNGP12.phx.gbl...
> Is the column that you are writing to a text column or varchar or char?
>
> It sounds like it is not text, if so make it a column of the text data
> type.
> If it is text, there is something wrong with the program you are using to
> input the data.

>
> "tshad" <tscheiderich@ftsolutions.com> wrote in message
> news:ewXtVmstEHA.904@TK2MSFTNGP11.phx.gbl...
>> I just ran into an example where the user put 8117 characters in the text
>> box and the text was truncated to 8000. This is just straight text and
>> we
>> want to be able to Full-Text index this field.
>>
>> What is the best way to deal with this? I was sure 8000 characters would
> be
>> enough. Most are only about 2K.
>>
>> Best laid plans!
>>
>> Thanks,
>>
>>
>
>

"tshad" <tscheiderich@ftsolutions.com> wrote in message
news:ewXtVmstEHA.904@TK2MSFTNGP11.phx.gbl...
> I just ran into an example where the user put 8117 characters in the text
> box and the text was truncated to 8000. This is just straight text and we
> want to be able to Full-Text index this field.
>
> What is the best way to deal with this? I was sure 8000 characters would
be
> enough. Most are only about 2K.
>
> Best laid plans!
>
> Thanks,
>
>

"tshad" <tscheiderich@ftsolutions.com> wrote in message
news:udC4aWttEHA.2876@TK2MSFTNGP14.phx.gbl...
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:%23lXbFEttEHA.820@TK2MSFTNGP12.phx.gbl...
> > Is the column that you are writing to a text column or varchar or char?
> >
> > It sounds like it is not text, if so make it a column of the text data
> > type.
> > If it is text, there is something wrong with the program you are using
to
> > input the data.
>
> At the moment, it is set to varchar (but there is an 8000 char limit). I
> didn't expect to even come close to that limit - but you know how it is.
>
> I had thought about using text, but someone said there was a limitation
> (which may not be a problem for me - not sure), where he said "There are
> limitations on text/ntext/image data types, such as not being table to
> declare local variables of these types".
>
> I just want to make sure I am not messing myself up. This is going to be
> used in my ASP.Net pages and accessed using VB.Net. The variable will
> mainly be going into a textbox object.
>
> Thanks,
>
> Tom.
>
> >
> > "tshad" <tscheiderich@ftsolutions.com> wrote in message
> > news:ewXtVmstEHA.904@TK2MSFTNGP11.phx.gbl...
> >> I just ran into an example where the user put 8117 characters in the
text
> >> box and the text was truncated to 8000. This is just straight text and
> >> we
> >> want to be able to Full-Text index this field.
> >>
> >> What is the best way to deal with this? I was sure 8000 characters
would
> > be
> >> enough. Most are only about 2K.
> >>
> >> Best laid plans!
> >>
> >> Thanks,
> >>
> >>
> >
> >
>
>