为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8 1-2-84-21.10.21-149328-10032-ENT
【操作系统】:windows 10
【CPU】:intel core i7
【问题描述】*:我把mysql8.0中的一张表迁移到dm8,在dm管理工具中,执行insert插入语句报字符串转换错误,请帮忙分析下如何解决,谢谢。
我的表结构是:
CREATE TABLE “SYSBASE”.“CONFERENCE”
(
“ID” INT IDENTITY(738, 1) NOT NULL,
“NAME” VARCHAR(255),
“TYPE” INT,
“STATUS” INT DEFAULT 40,
“START_TIME” TIMESTAMP(0),
“END_TIME” TIMESTAMP(0),
“REMARK” VARCHAR(500),
“SUB_TYPE” INT,
“PIN” VARCHAR(255),
“SECURITY” INT,
“SEC_LEVEL” INT DEFAULT 0,
“USER_ORG_ID” INT,
“PRESENTER_ID” INT,
“REAL_START_TIME” TIMESTAMP(0),
“REAL_END_TIME” TIMESTAMP(0),
“CANCEL_TIME” TIMESTAMP(0),
“CONF_SOURCE” INT,
“IS_PERIODIC” VARCHAR(255),
“GUEST_ACCESS” BIT DEFAULT ‘0’,
“DELETE_SERVER_DOC_AFTER_END” BIT,
“IS_TEMPLATE” BIT DEFAULT ‘0’,
“ROTATION” INT,
“IS_SHOW” BIT DEFAULT ‘1’,
“IS_ALL_DAY” BIT DEFAULT ‘0’,
“GMT_CREATE” TIMESTAMP(0),
“GMT_MODIFIED” TIMESTAMP(0),
“CREATE_BY” INT,
“UPDATE_BY” INT,
“IS_DELETED” TINYINT DEFAULT 0,
“IS_REPEATED” INT DEFAULT 0,
“REPEATED” VARCHAR(36),
“IS_REMIND” INT DEFAULT 0,
“REMIND_WAY” INT DEFAULT 2,
“PARENT_ID” INT,
“LOGO_FILE_ID” VARCHAR(255),
“LOGO_FILE_TYPE” INT DEFAULT 0,
“CONF_BEFORE_STATUS” INT DEFAULT 0,
“NEED_CONTENT” CLOB,
“IS_READY” TINYINT DEFAULT 0,
“IS_WAITING” BIT,
“APPROVE_NUMBER” INT,
“IS_APPROVE” BIT DEFAULT ‘0’ NOT NULL,
“FLOW_ID” INT,
“APPROVE_STATUS” INT,
“SUBMIT_TIME” TIMESTAMP(0),
NOT CLUSTER PRIMARY KEY(“ID”)) STORAGE(ON “MAIN”, CLUSTERBTR) ;
使用如下插入语句,会显示”字符串转换出错“,请帮忙分析下原因。
INSERT INTO “SYSBASE”.“CONFERENCE”(“ID”, “NAME”, “TYPE”, “STATUS”, “START_TIME”, “END_TIME”, “REMARK”, “SUB_TYPE”, “PIN”, “SECURITY”, “SEC_LEVEL”, “USER_ORG_ID”, “PRESENTER_ID”, “REAL_START_TIME”, “REAL_END_TIME”, “CANCEL_TIME”, “CONF_SOURCE”, “IS_PERIODIC”, “GUEST_ACCESS”, “DELETE_SERVER_DOC_AFTER_END”, “IS_TEMPLATE”, “ROTATION”, “IS_SHOW”, “IS_ALL_DAY”, “GMT_CREATE”, “GMT_MODIFIED”, “CREATE_BY”, “UPDATE_BY”, “IS_DELETED”, “IS_REPEATED”, “REPEATED”, “IS_REMIND”, “REMIND_WAY”, “PARENT_ID”, “LOGO_FILE_ID”, “LOGO_FILE_TYPE”, “CONF_BEFORE_STATUS”, “NEED_CONTENT”, “IS_READY”, “IS_WAITING”, “APPROVE_NUMBER”, “IS_APPROVE”, “FLOW_ID”, “APPROVE_STATUS”, “SUBMIT_TIME”) VALUES (450,‘cgv’,1,40,‘2021-12-17 19:30:00’,‘2021-12-17 20:30:00’,NULL,1,‘’,0,0,NULL,NULL,‘2021-12-17 19:30:00’,‘2021-12-17 20:30:00’,NULL,0,NULL,_binary ‘<’,NULL,_binary ‘\0’,NULL,_binary ‘<’,_binary ‘\0’,‘2021-12-17 19:17:40’,‘2021-12-17 19:17:40’,108,108,1,0,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,NULL,NULL,_binary ‘\0’,NULL,NULL,NULL)
bit类型 直接写值即可 不需要前面那些
这是个啥?