此帖子已被社区举报，现已被临时隐藏。
请问observer是商业版吗？商业版可以向商业版客服咨询。
CREATE TABLE ipt_dailycourser_table (
HID varchar(50) CHARACTER SET gbk NOT NULL DEFAULT ‘’,
PATIENTID varchar(50) DEFAULT ‘’,
ORGANIZATIONNANME varchar(256) DEFAULT ‘’,
ORGANIZATIONCODE varchar(256) NOT NULL DEFAULT ‘’,
HOSPITALCODE varchar(256) DEFAULT ‘’,
JZLSH varchar(50) DEFAULT ‘’,
BUSINESS_LOCAL_ID varchar(50) CHARACTER SET gbk DEFAULT ‘’,
HOSPIZATIONID varchar(50) DEFAULT ‘’,
DEPTNAME varchar(100) DEFAULT ‘’,
WARDAREANM varchar(100) DEFAULT ‘’,
SICKROOMID varchar(50) DEFAULT ‘’,
SICKBEDID varchar(50) DEFAULT ‘’,
RECORDERDATETIME datetime(6) DEFAULT NULL,
HEAD_PERSONNAME varchar(50) DEFAULT ‘’,
HEAD_SEXCODE varchar(1) DEFAULT ‘’,
AGE decimal(8,0) DEFAULT NULL,
AGE_MONTH varchar(5) DEFAULT ‘’,
HEAD_BIRTHDAY datetime(6) DEFAULT NULL,
HEAD_IDTYPE varchar(2) DEFAULT ‘’,
HEAD_IDCARD varchar(50) DEFAULT ‘’,
HEAD_ADDRESSTYPE varchar(2) DEFAULT ‘’,
HEAD_FFLAG varchar(1) DEFAULT ‘’,
HEAD_ADDRESS varchar(1000) DEFAULT ‘’,
KH varchar(32) DEFAULT ‘’,
KLX varchar(2) DEFAULT ‘’,
HEAD_CONTACTNO varchar(32) DEFAULT ‘’,
HOSPIZATIONDURATION longtext DEFAULT NULL,
ADVICECONTENT longtext DEFAULT NULL,
CHINESEFOUROBSERVATIONDESCRIPT longtext DEFAULT NULL,
SYNDROMEDIFFERENTIATIONANDTREA longtext DEFAULT NULL,
CHINESEHERBALMEDICINEMETHOD varchar(1000) DEFAULT ‘’,
CHINESEMEDICINEDECOCTINGMETHOD varchar(1000) DEFAULT ‘’,
ADMISSIONDATETIME datetime(6) DEFAULT NULL,
PROFESSIONALTECHNICALPOSTCODE varchar(1) DEFAULT ‘’,
DOCTORSIGN varchar(100) DEFAULT ‘’,
SIGNDATETIME datetime(6) DEFAULT NULL,
CITY_P varchar(256) DEFAULT ‘’,
COUNTRY_P varchar(256) DEFAULT ‘’,
EFFECTIVETIME_P datetime(6) DEFAULT NULL,
UPDATEDATE datetime(6) DEFAULT NULL,
UPLOADTIME_P datetime(6) DEFAULT NULL,
CHECKID varchar(500) DEFAULT ‘’,
LAST_DATE datetime(6) DEFAULT NULL,
CHECKTIME datetime(6) DEFAULT NULL,
STATE char(1) DEFAULT NULL,
STARTTIME datetime(6) DEFAULT NULL,
ENDTIME datetime(6) DEFAULT NULL,
PRIMARY KEY (HID, ORGANIZATIONCODE)
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
请问用的是什么导数工具？
oracle部分字符集社区版是没有的，需要先修改字符集为社区版存在的字符集或者使用OMS导数工具