Weird error

[Shawn]

I'm getting this error when Trying to insert a field into
a sql server db using a stored procedure.

String or binary data would be truncated.
-- code --
CREATE PROCEDURE insertApplication
@param char(2086)
....
INSERT INTO tblTest
(
[datetime], status, bigfield
)
VALUES
(
getdate(), @status,@param
)

-- end --

When I change the input parameter to 2048 it works fine,
but does not store all the fields.

The length of the field coming in is 2086. Why does it
give me an error when I increase it past 2048, but when it
is 2048 if works find but cuts off my results?

[shawn]

Duh,

I found it. Sorry for taking up space.

>-----Original Message-----
>I'm getting this error when Trying to insert a field into
>a sql server db using a stored procedure.
>
>String or binary data would be truncated.
>-- code --
>CREATE PROCEDURE insertApplication
> @param char(2086)
>....
>INSERT INTO tblTest
> (
> [datetime], status, bigfield
> )
> VALUES
> (
> getdate(), @status,@param
> )
>
>-- end --
>
>When I change the input parameter to 2048 it works fine,
>but does not store all the fields.
>
>The length of the field coming in is 2086. Why does it
>give me an error when I increase it past 2048, but when

it

>is 2048 if works find but cuts off my results?
>.
>