I cannot get the BIT datatype working with the MyStoredProc component and MySQL 5. I'm using the latest version of MyDAC.
Whenever I try to use AsBoolean for a parameter, I get an error like this:
>>>#22001Data too long for column 'b' at row 1.
Simple procedure source code and table:
Code: Select all
CREATE TABLE newtab (
i Integer,
d Date,
dt DateTime,
t Time,
b Bit
)
CREATE PROCEDURE newtab_I(i Integer, dt DateTime, d Date, t Time, b Bit)
BEGIN
INSERT INTO newtab (
i, d, dt, t, b)
VALUES (
i, d, dt, t, b);
END
--
Martijn Tonies
Upscene Productions