[dba-SQLServer] varchar limits

David Emerson davide at dalyn.co.nz
Mon May 24 19:42:17 CDT 2004


Found the problem - I had a CAST(@txtAct2yyyymm AS nvarchar(6)) which must 
have converte dthe whole variable to nvarchar.  Changing it to varchar 
solved it.

David

At 25/05/2004, you wrote:
>SQL2000.
>
>I have the following declaration in a stored procedure -
>
>         declare @qs varchar(8000)
>
>However, when I assign a string to the variable it seems to truncate at 
>4000 characters.  My understanding is that varchar can have up to 8000 
>characters.  Is there something I am missing?
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>25 Cunliffe St, Churton Park
>Wellington, New Zealand
>Ph/Fax (04) 478-7456
>Mobile 027-280-9348 _______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (04) 478-7456
Mobile 027-280-9348 




More information about the dba-SQLServer mailing list