string truncating on insert

Results 1 to 2 of 2

Thread: string truncating on insert

  1. #1
    Join Date
    Dec 1969

    Default string truncating on insert

    I&#039;m inserting email addresses into a field called "email" on our database (or trying to) - if I enter an address with anything more than 15 characters I get an error:<BR><BR>Microsoft OLE DB Provider for SQL Server error &#039;80040e57&#039; <BR><BR>String or binary data would be truncated. <BR><BR>The paramater is dimensioned in the SP as varchar(100) and in the database its a nvarchar(100). Any ideas why this would happen? (when I response.write it to the process page it comes out fine)

  2. #2
    Join Date
    Dec 1969

    Default Error in invoking the SP???

    Maybe you have the field order scrambled and are trying to put email into zipcode which *is* defined as varchar(15)???<BR><BR>Is there *ANY* field defined as varchar(15) or char(15) or similar????<BR><BR>I know, I know, this is the obvious stuff. But you haven&#039;t given us much to go on.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts