数据库生僻字无法识别

OceanBase 技术问题
#1

龑的简体字数据库无法识别 我的字符集是GBK

#3

什么版本的？

#4

无法识别是什么意思？插入失败还是什么

#5

插入后会变成?

#6

能给一下表结构，插入语句吗

#7

版本号也给一下，我们这边复现看看

#8

我自己再看看

#9

情况如何？

#10

目前测试了 字符集是GBK的都没法识别 Unicode的直接可以认出这个字

#11

比如㼆,这个字的简体字在数据库无法识别,报错信息是incurrent value

#12

/*
Navicat Premium Data Transfer

Source Server : 主2 集群
Source Server Type : MySQL
Source Server Version : 50625
Source Host : 192.168.9.29:2883
Source Schema : rkjkpt

Target Server Type : MySQL
Target Server Version : 50625
File Encoding : 65001

Date: 04/12/2023 16:04:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

– Table structure for base_person_ylfw

DROP TABLE IF EXISTS base_person_ylfw;
CREATE TABLE base_person_ylfw (
HID varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT ‘������’,
PATIENTID varchar(256) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����Ժ��Ψһ��ʶ��’,
ORGANIZATIONNANME varchar(256) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��������’,
ORGANIZATIONCODE varchar(256) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT ‘��������’,
HOSPITALCODE varchar(256) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘ҽԺԺ������’,
KLX varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘������’,
KH varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����’,
HEALTH_FILE_NO varchar(18) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘������񽡿�������’,
HEALTHCARDID varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘���񽡿�����’,
HEAD_IDTYPE varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘���֤��������’,
HEAD_IDCARD varchar(70) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘���֤����’,
SFRZJB varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘�����֤����’,
HEAD_PERSONNAME varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��������’,
HEAD_SEXCODE varchar(1) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘�Ա�’,
HEAD_FFLAG varchar(1) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘���б�־’,
HEAD_BIRTHDAY datetime(0) NULL DEFAULT NULL COMMENT ‘��������’,
MZ varchar(5) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����’,
GJ varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����’,
HY varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����״������’,
ZY varchar(5) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘ְҵ������’,
EDUCATIONNAME varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘�Ļ��̶�’,
HEAD_CONTACTNO varchar(40) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘���ߵ绰����’,
GZDWMC varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘������λ����’,
WORKADDRPHONE varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘������λ�绰����’,
GZDWJDZ varchar(500) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘������λ��ַ’,
HEAD_ADDRESSTYPE varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ַ���’,
HEAD_ADDRESS varchar(500) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ַ’,
HKDZ varchar(500) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘���ڵ�ַ’,
PRESENTADDRPROVINCE varchar(70) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ס��ַ-ʡ����������ֱϽ�У�’,
PRESENTADDRCITY varchar(70) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ס��ַ-�У��������ݣ�’,
PRESENTADDRCOUNTY varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ס��ַ-�أ�����’,
XZZXZ varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ס��ַ-�磨�򡢽ֵ����´���’,
XZZC varchar(70) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ס��ַ-�壨�֡�·��Ū�ȣ�’,
XZZMP varchar(70) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ס��ַ-���ƺ���’,
INPUT_DATE datetime(0) NULL DEFAULT NULL COMMENT ‘��������ʱ��’,
INPUT_ORGAN_CODE varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����ҽ�ƻ�������’,
INPUT_ORGAN_NAME varchar(70) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����ҽ�ƻ�������’,
INPUT_ID varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘������ID’,
INPUT_NAME varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����������’,
LXRYHZGX varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ϵ���뻼�߹�ϵ����’,
LXRXM varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ϵ������’,
LXRDH varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ϵ�˵绰’,
LXRSFZJHM varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ϵ�����֤������’,
LXRSFZJLBDM varchar(2) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ϵ�����֤��������’,
LXRDZ varchar(500) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘��ϵ�˵�ַ’,
DOMAIN_CODE varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘�����’,
DOMAIN_NAME varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘������’,
CITY_P varchar(256) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����’,
COUNTRY_P varchar(256) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT ‘����’,
EFFECTIVETIME_P datetime(0) NULL DEFAULT NULL COMMENT ‘ҵ������ʱ��’,
UPDATEDATE datetime(0) NULL DEFAULT NULL COMMENT ‘�����ϴ�ʱ��’,
UPLOADTIME_P datetime(0) NULL DEFAULT NULL COMMENT ‘��дʱ��’,
CHECKID varchar(500) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
LAST_DATE datetime(0) NULL DEFAULT NULL,
CHECKTIME datetime(0) NULL DEFAULT NULL,
STATE char(1) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
STARTTIME datetime(0) NULL DEFAULT NULL,
ENDTIME datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (HID, ORGANIZATIONCODE) USING BTREE,
INDEX BASE_PERSON_YLFW_E_C(CITY_P) USING BTREE,
INDEX EP_BASE_PERSON_YLFW(EFFECTIVETIME_P) USING BTREE,
INDEX ID_BASE_PERSON_YLFW(HID) USING BTREE,
INDEX JG_BASE_PERSON_YLFW(ORGANIZATIONCODE, EFFECTIVETIME_P, STATE) USING BTREE,
INDEX LE_BASE_PERSON_YLFW(LAST_DATE) USING BTREE,
INDEX PATIENTID_BASE_PERSON_YLFW(PATIENTID, ORGANIZATIONCODE) USING BTREE,
INDEX SJ_BASE_PERSON_YLFW(INPUT_DATE) USING BTREE
) ENGINE = oceanbase CHARACTER SET = gbk COLLATE = gbk_chinese_ci COMMENT = ‘���߻�����Ϣ’ ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;