PDA

Click to See Complete Forum and Search --> : Stored Procedure varchar i/p parameter max length

pm
08-01-2001, 02:08 PM
How long the input parameter of varchar type can be.
I have declared a variable of type varchar and size 255.
When I pass string of more than 128 characters, error occurs
both thru ADO and Query Analyser.
DaveSatz
08-01-2001, 04:08 PM
Almost sounds like you are sending unicode data ? You s/b able to have a
varchar parameter up to 8000 bytes in SQL7+
--
HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
->Using SQL Server 2000 SP1/7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"pm" <pm417@hotmail.com> wrote in message news:3b6845b9$1@news.devx.com...
>
> How long the input parameter of varchar type can be.
> I have declared a variable of type varchar and size 255.
> When I pass string of more than 128 characters, error occurs
> both thru ADO and Query Analyser.
>