SEO

#1 (**permalink**) 02-29-2008, 04:26 AM

Hi,

I have a form which is submitting into a sql server db. i have one of
the fields set to ntext which says length of 16. when i insert info,
it only sumbits about a paragraph and when i pull this back using
analyser it amounts to a byte count of 256 bytes. i thought you could
submit pages of info using ntext??

i had been trying to use varchar with a length of 7000, but for some
reason only info on the one line is submitted. if the user uses a
line break, then nothing after that is submitted.

Any help greatly appreciated.

#2 (**permalink**) 02-29-2008, 04:26 AM

Tools / Options / Results. Set the "Maximum characters per column" setting
to a larger value.

--
David Portas
SQL Server MVP
--

#3 (**permalink**) 02-29-2008, 04:27 AM

"kieran" <kieran5405@hotmail.com> wrote in message
news:b39796b3.0410041029.5fd8efbc@posting.google.c om...
> Hi,
>
> I have a form which is submitting into a sql server db. i have one of
> the fields set to ntext which says length of 16. when i insert info,
> it only sumbits about a paragraph and when i pull this back using
> analyser it amounts to a byte count of 256 bytes. i thought you could
> submit pages of info using ntext??

Not the 16 is the of the pointer.

>
> i had been trying to use varchar with a length of 7000, but for some
> reason only info on the one line is submitted. if the user uses a
> line break, then nothing after that is submitted.
>
> Any help greatly appreciated.

#4 (**permalink**) 02-29-2008, 04:28 AM

"kieran" <kieran5405@hotmail.com> wrote in message
news:b39796b3.0410041029.5fd8efbc@posting.google.c om...
> Hi,
>
> I have a form which is submitting into a sql server db. i have one of
> the fields set to ntext which says length of 16. when i insert info,
> it only sumbits about a paragraph and when i pull this back using
> analyser it amounts to a byte count of 256 bytes. i thought you could
> submit pages of info using ntext??
>
> i had been trying to use varchar with a length of 7000, but for some
> reason only info on the one line is submitted. if the user uses a
> line break, then nothing after that is submitted.
>
> Any help greatly appreciated.

You may have a data type problem or you may have a problem with your
front-end, either in how the input data is handled or in how the output data
is displayed.

For instance, Access grids seem to ignore anything after a line break by
default. You may have successfully stored multiple lines of text (a string
with embedded cr/lf s) but then be unable to display anything after the
initial cr/lf by opening the table in MS Access.

You're going to have to look at the whole system involved (front-end tools,
database server, table defnitions, etc) to isolate the cause of your
problem.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

urgent - data type problem