sql, when i running the below SQL command i receieved the following error

Posted on 2011-10-05
Last Modified: 2012-08-14
insert into customer (code, name, addr1, city, state, zip, phone1, phone2, fax1, contact1, user1, salesrep1, terms, shipvia, active, pricelevel, user4, userid, user_date, country, factored, duplicate_po, default_wh, memo_code, box_mode, currency, autoprint ) values ('STEELS', 'STEELS ', '601 Jacksonville Warehouse 506 Bealls Blvd.', 'Jacksonville', 'TX', '75766', '713-6675601', '713-6675601', '', 'ROBIN COX', 'CIT', 'RK', 'N45', '', '1', 'A', 'A', 'NIR', '2011-10-05', '',  'Y', 'Y', '00', 'CIT', '0', 'USD', 'N')


Server: Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.

please advice
Question by:gvilbis
    1 Comment
    LVL 45

    Accepted Solution

    Hi gvilbis,

    I suspect that one of your strings is longer than the column definition.  Make sure that all of the VARCHAR objects are large enough to contain the entire string that you need to store.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now