| Subject | Re: Overflow occured during datatype conversion. Conversion error from string "BLOB" |
|---|---|
| Author | zzotnik |
| Post date | 2008-04-01T18:19:55Z |
Dear Woody,
Here is the declaration of the other table:
CREATE TABLE INVOICEITEMS (
ITEMID INTEGER NOT NULL,
INVOICEID INTEGER NOT NULL,
QUANTITY INTEGER NOT NULL,
ITEMNETPRICE DECIMAL(18, 2) NOT NULL,
VATTEXT VARCHAR(50) CHARACTER SET ISO8859_2 COLLATE ISO8859_2,
VATPERCENTAGE INTEGER NOT NULL);
Here is the declaration of the other table:
CREATE TABLE INVOICEITEMS (
ITEMID INTEGER NOT NULL,
INVOICEID INTEGER NOT NULL,
QUANTITY INTEGER NOT NULL,
ITEMNETPRICE DECIMAL(18, 2) NOT NULL,
VATTEXT VARCHAR(50) CHARACTER SET ISO8859_2 COLLATE ISO8859_2,
VATPERCENTAGE INTEGER NOT NULL);