mysql> desc MSGDB_20060330; +---------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+-------+ | CREATETIME | char(14) | NO | | | | | MESSAGEUUID | char(33) | YES | MUL | | | | SMSSEQ | int(10) unsigned | NO | PRI | 0 | | | DESTTERMID | varchar(80) | YES | | | | | MSGOVER | smallint(6) | YES | | | | | ERRORCODE | int(11) | YES | | | | | MSGIDREPLY | bigint(20) unsigned | YES | MUL | | | | OVERTIME | char(14) | YES | | | | | REPLYOVER | smallint(6) | YES | | | | | REPLYOVERTIME | char(14) | YES | | | | | MSGSTATUS | varchar(20) | YES | | | | +---------------+---------------------+------+-----+---------+-------+
SMSSEQ is int unsigned. This is part of my code: unsigned int parm_smsSeq_; bindResParm_[parmNum].buffer_type = MYSQL_TYPE_LONG; bindResParm_[parmNum].buffer = (char*)&parm_smsSeq_; bindResParm_[parmNum].is_null = 0; bindResParm_[parmNum].length = 0; When parm_smsSeq is grater than max value of signed int, I always get an zero value in that table after INSERT INTO SMSSEQ. Please help me. regards, gu lei 祝您工作顺利,身体健康,家庭和睦,一切吉祥。 古雷 中企动力科技集团 技术架构部