Okay, I'm stumped...

    Date: 09/23/05 (SQL Server)    Keywords: no keywords

    the error message:
    "The conversion of the verchar value 'xxxxxxxxxxxx' overflowed an INT1 column. Use a large intereger column."

    The column is char(10). (The value is, actually, numeric; I x'ed it because it's a phone number.)

    I've checked, double-checked, and triple-checked that (a) the INSERT INTO statement is putting the value in the right place; (b) the table does have the column listed as char(10); (c) the variable names are consistent across the board in putting the INSERT INTO statement together.

    Anything else I should be looking at?

    Source: http://www.livejournal.com/community/sqlserver/35281.html

« SQL Server Remote Query... || Using SQL Server to... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home