将unicode文本插入Oracle数据库表(Insert unicode text into Oracle database table)

将unicode文本插入Oracle数据库表(Insert unicode text into Oracle database table)

我通过SQL Developer 4.1.1在OracleDB 11c中创建了一个表

CREATE TABLE FAC.FAC_CODE_CPQLDN( ID NUMBER(10), CODE NVARCHAR2(100) NOT NULL, NAME NLOB, NOTE NLOB, PARENT_ID NUMBER(10), CONSTRAINT FAC_CODE_CPQLDN_PK PRIMARY KEY (ID) );

之后，我将数据插入此表

REM INSERTING into FAC_CODE_CPQLDN SET DEFINE OFF; insert into FAC_CODE_CPQLDN(ID, CODE, NAME, NOTE, PARENT_ID) values (1, 'C1.1', 'Chi phí công ty', '', 0);

但是我得到了错误

SQL Error: ORA-01465: invalid hex number

请让我知道如何解决它？

I create a table in OracleDB 11c through SQL Developer 4.1.1

CREATE TABLE FAC.FAC_CODE_CPQLDN( ID NUMBER(10), CODE NVARCHAR2(100) NOT NULL, NAME NLOB, NOTE NLOB, PARENT_ID NUMBER(10), CONSTRAINT FAC_CODE_CPQLDN_PK PRIMARY KEY (ID) );

After that, I insert data into this table

REM INSERTING into FAC_CODE_CPQLDN SET DEFINE OFF; insert into FAC_CODE_CPQLDN(ID, CODE, NAME, NOTE, PARENT_ID) values (1, 'C1.1', 'Chi phí công ty', '', 0);

But I get the error

SQL Error: ORA-01465: invalid hex number

Please let me know how to fix it?

最满意答案

尝试在插入BLOB字段之前将varchar2值转换为RAW格式 -

insert into FAC_CODE_CPQLDN(ID, CODE, NAME, NOTE, PARENT_ID) values (1, 'C1.1', UTL_RAW.CAST_TO_RAW('Chi phí công ty'), null, 0);

Try to convert varchar2 values to RAW-format before insert into BLOB fields -

insert into FAC_CODE_CPQLDN(ID, CODE, NAME, NOTE, PARENT_ID) values (1, 'C1.1', UTL_RAW.CAST_TO_RAW('Chi phí công ty'), null, 0);