Post reply

String or binary data would be truncated.

  • December 2, 2007 at 9:48 pm

    #179738

    I have a SP where i have given SET ANSI_WARNINGS ON. Inside the SP i am creating a temp table (# table) where i am inserting a record which is greater than its defined length. i.e the column of temp table is nvarchar(30) and i am trying to insert 31 characters. In one server the string data is truncated to 30 chars and inserted whereas when i execute the same in another server it is giving error like String or binary data would be truncated. Please provide the reason for this

  • December 2, 2007 at 10:33 pm

    #756360

    Hi !

    Increase the lenght of your column.

  • December 3, 2007 at 6:18 am

    #756439

    Hi,

    Thanks for the response. But my query is why the record is getting inserted in one Server by truncating the last character and why it is throwing the error in another server.

  • December 3, 2007 at 6:25 am

    #756441

    Is the SET option defined at the PROCEDURE level?

    --Ramesh

  • December 3, 2007 at 11:49 pm

    #756789

    Yes it is set in Procedure

  • January 18, 2013 at 4:02 am

    #1578623

    yes the set option is defined at the procedural level

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply