Cannot Update Golang Bool value to TINYINT column

[ikingme]

I have a table with column tinyint in my database. In my code the field is bool in a struct. I can't update the value to the tinyint column.

table: CREATE TABLE "TBL_PERSON" ( "ID" BIGINT IDENTITY(1,1) NOT NULL, "NAME" VARCHAR(384) DEFAULT '' NOT NULL, "GENDER" TINYINT DEFAULT 0 NOT NULL, "AGE" INT DEFAULT 1 NOT NULL );

struct: type TblPerson struct { Id uint32 orm:"column(id)";pk Name string Gender bool Age int }

code:

1. db.Exec("update tbl_person set gender = true where id = 28") is OK
2. db.Exec("update tbl_person set gender = ? where id = ?", true, 28) doesn't work

[alexbrainman]

@ikingme ,

I have no idea how to help you.

Alex