为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:0x7000c , DM Database Server:64 V8
【操作系统】:windows
【CPU】:
【问题描述】*:你好,求助帮忙,我已经在控制台工具那里将ENABLE_CS_CVT修改为1,数据库使用的字符集编码是UTF-8,现在想将查询字段转为GB18030,提示无效的数据类型,这是什么问题?
建表语句:
CREATE TABLE "yqyc_basic"."yqyc_vehicle"
(
"id" BIGINT IDENTITY(2506, 1) NOT NULL,
"public_flag" INT DEFAULT 0 NOT NULL,
"ding_corp_id" VARCHAR(64 CHAR) NOT NULL,
"group_no" BIGINT DEFAULT 1 NOT NULL,
"group_id" BIGINT DEFAULT 1 NOT NULL,
"backup_power_time_limit" INT DEFAULT 0,
"private_user_id" DECIMAL(20,0),
"status" CHAR(3) DEFAULT 'P' NOT NULL,
"share_mode" INT DEFAULT 1 NOT NULL,
"location_mode" INT DEFAULT 1 NOT NULL,
"had_joined" INT DEFAULT 1 NOT NULL,
"allowance_per_km" DEC(10,2),
"submit_type" INT DEFAULT 0 NOT NULL,
"license_plate_no" VARCHAR(30 CHAR) DEFAULT '',
"frame_no" VARCHAR(100 CHAR) DEFAULT '',
"brand_id" BIGINT,
"brand_name" VARCHAR(100 CHAR) DEFAULT '',
"brand_photo" VARCHAR(500 CHAR) DEFAULT '',
"serial_id" BIGINT,
"serial_name" VARCHAR(100 CHAR) DEFAULT '',
"driver_id" DECIMAL(20,0),
"load_number" INT,
"department_id" BIGINT,
"department_name" VARCHAR(64 CHAR),
"schedule" INT DEFAULT 0,
"un_reserve_starttime" TIMESTAMP(0),
"un_reserve_endtime" TIMESTAMP(0),
"duty_state" INT,
"moving_state" INT,
"monitor_flag" INT DEFAULT 1 NOT NULL,
"driving_level" VARCHAR(10 CHAR),
"create_date" TIMESTAMP(0),
"create_by" DECIMAL(20,0),
"update_date" TIMESTAMP(0),
"update_by" DECIMAL(20,0),
"del_flag" INT DEFAULT 0,
"next_commercial_insurance_time" TIMESTAMP(0),
"next_maintenance_time" TIMESTAMP(0),
"next_maintenance_mileage" DECIMAL(10,2),
"next_inspection_time" TIMESTAMP(0),
"current_mileage" DECIMAL(10,2),
"vehicle_tag" VARCHAR(255 CHAR),
"next_traffic_insurance_time" TIMESTAMP(0),
"displacement" DECIMAL(3,1),
"current_parked_address" VARCHAR(500 CHAR),
"private_ding_user_id" VARCHAR(64 CHAR),
"is_enabled" BIGINT DEFAULT 1,
"energy_type" INT DEFAULT 1,
"vehicle_type" VARCHAR(100 CHAR),
"owner" VARCHAR(100 CHAR),
"use_nature" VARCHAR(100 CHAR),
"address" VARCHAR(100 CHAR),
"engine_number" VARCHAR(100 CHAR),
"issue_date" TIMESTAMP(0),
"registration_date" TIMESTAMP(0),
"curb_weight" DECIMAL(10,2),
"total_weight" DECIMAL(10,2),
"inspection_record" VARCHAR(100 CHAR),
"record_number" VARCHAR(100 CHAR),
"vehicle_license_face" VARCHAR(500 CHAR),
"vehicle_license_back" VARCHAR(500 CHAR),
"license_vehicle_photo" VARCHAR(500 CHAR),
"fuel_card_id" INT,
NOT CLUSTER PRIMARY KEY("id")
目前只支持 ZHS16GBK、AL32UTF8、UTF8 和 ZHS32GB18030 四种字符集。
Select convert('abc', 'ZHS32GB18030', 'UTF8') from dual;