urgent - data type problem

[kieran]

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.

[David Portas]

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

--
David Portas
SQL Server MVP
--

[Greg D. Moore \(Strider\)]

"kieran" <ki********@hotmail.com> wrote in message
news:b3**************************@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.

[DHatheway]

"kieran" <ki********@hotmail.com> wrote in message
news:b3**************************@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.