Test table:

CREATE TABLE TEST (
    ID INTEGER NOT NULL,
    QUANTITY1 INTEGER NOT NULL,
    QUANTITY2 SMALLINT NOT NULL,
    QUANTITY3 NUMERIC(15,2) NOT NULL,
    QUANTITY4 DOUBLE PRECISION NOT NULL
);

data:


INSERT INTO TEST (ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4) VALUES (1, 1, 2, 3, 4);
INSERT INTO TEST (ID, QUANTITY1, QUANTITY2, QUANTITY3, QUANTITY4) VALUES (2, 22, 34, 23, 12);

Calling this select, odbc returns wrong type of column Q1 and Q2

SELECT SUM(QUANTITY1) AS Q1,SUM(QUANTITY2) AS Q2,SUM(QUANTITY3) AS Q3,SUM(QUANTITY4) AS Q4 FROM TEST

Obc returns q1 and q2 as string

This workaround fix this problem.

SELECT CAST(SUM(QUANTITY1) AS INTEGER) AS Q1,CAST(SUM(QUANTITY2) AS INTEGER) AS Q2,SUM(QUANTITY3) AS Q3,SUM(QUANTITY4) AS Q4 FROM TEST