NVARCHAR2 character set mismatch issues in Oracle

Oracle encountered NVARCHAR2 type times error when making character match, prompting for character set mismatch.

For places where you use NVARCHAR2, you need to convert the fields into characters, plus the To_char (nvarchar2 field).

For example:

SELECT substr (BM.MATNR, 3) WLBM, Ms.maktx Wlms, Bm.meins jldw, Bm.matkl Wlz
, bm.normt Gybzms,bm.laeda GXSJ, (case to_char (trim (bm.lvorm)) if ' X ' then ' 0 ' else ' 1 ' end) Wlzt
From Makt MS, Mara BM
WHERE Ms.matnr = Bm.matnr;

VARCHAR2 is a specific data type provided by Oracle, and Oracle can guarantee that the data type is up and backwards compatible in any version of VARCHAR2.

VarChar is not recommended for use in Oracle.

the difference between NVARCHAR2 and VARCHAR2:

From a usage perspective, the difference is that NVARCHAR2 is related to character sets when calculating the length, such as when the database is a Chinese character set with length 10 as an example, then

1, NVARCHAR2 (10) is can be stored in 10 Chinese characters, if used to save English can only save 10 characters.

2, and VARCHAR2 (10), then only 5 characters can be stored in English, 10.

NVARCHAR2 character set mismatch issues in Oracle