DB中的字符集支持就可以，请先确认你的字符集

SQL> 
SQL> select *
  2  	from nls_database_parameters
  3   where parameter in ('NLS_NCHAR_CHARACTERSET', 'NLS_CHARACTERSET');

PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_CHARACTERSET               AL32UTF8

SQL> create table t_char (c1 varchar2(20),c2 nvarchar2(20));

Table created

SQL> insert into t_char values('踇','踇');

1 row inserted


SQL> select * from t_char;

C1                   C2
-------------------- -----------------------------------------
踇                   踇

SQL> 
复制

你好，踇字可以插入，但是𧿹字不行，我们要插入𧿹字到数据库，麻烦帮忙看看怎么插入，谢谢

select *
    from nls_database_parameters
          where parameter in ('NLS_NCHAR_CHARACTERSET', 'NLS_CHARACTERSET');

PARAMETER		       VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET	       AL16UTF16
NLS_CHARACTERSET	       ZHS16GBK

SQL> create table t_char (c1 varchar2(20),c2 nvarchar2(20));

Table created.

SQL> insert into t_char values('踇','踇');

1 row created.

SQL> select * from t_char;

C1		     C2
-------------------- ----------------------------------------
踇		     踇

SQL> insert into t_char values('踇','𧿹');

1 row created.

SQL> select * from t_char;

C1		     C2
-------------------- ----------------------------------------
踇		     踇
踇		     ??

复制

UTF32 可以

SQL> 
SQL> create table t_utf32(c1 varchar2(20));

Table created


SQL> insert into t_utf32 values('踇');

1 row inserted


SQL> insert into t_utf32 values('𧿹');

1 row inserted


SQL> select * From t_utf32;

C1
--------------------
踇
𧿹

SQL> 
SQL> select *
  2   	from nls_database_parameters
  3    where parameter in ('NLS_NCHAR_CHARACTERSET', 'NLS_CHARACTERSET');

PARAMETER                      VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_CHARACTERSET               AL32UTF8
NLS_NCHAR_CHARACTERSET         AL16UTF16

SQL> 

复制