ADO Command, String data, right truncation on varchar 
Author Message
 ADO Command, String data, right truncation on varchar

Im using SQL2000/ASP/JavaScript.

I have an sp that takes as inputs two parameters of varchar(3000)

so in my asp i have:

...

3000, cmd_cd__CallDescrip));

cmd_cd__CallSol));
...

Which works fine as long as the strings that are sent are <255 chars. If the
strings are >255 chars i get the following error:

        [Microsoft][ODBC SQL Server Driver]String data, right truncation

I am sending the data from a form using post, and the collecting the data
using String(Request("...

Can anyone give me any clues as to why the command is failing.

Many Thanks

SSS



Sat, 03 Jan 2004 19:34:55 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Fractional Truncation, String Data, right truncation.

2. String Data Right Truncation

3. string data, right truncation sqlstate = 22001

4. [ODBC SQL Server Driver]String data, right truncation

5. String data right truncation

6. [ODBC SQL Server Driver]String data, right truncation

7. ODBC ERROR : "String data right truncation..."

8. Error 22001 : [Microsoft][ODBC SQL Server Driver]String data right truncation

9. String Data, right truncation

10. 01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right truncation

11. String data, right truncation

12. string data right truncation on cn.open


 
Powered by phpBB® Forum Software