MTK Parameter

Parameter

charAppendEmptyString

Type: bool

Desc: For ORA-29275: Partial multibyte character error.

When parameters are enabled, the Oracle query statement stitches the empty string. Support types

Char
Character
NChar
Varchar
NVarchar
Varchar2
NVarchar2

select chr(195) from dual;         -- ORA-29275
select chr(195)||'' from dual;     -- normal

-- Chinese "证券投" GBK encoding
select utl_raw.cast_to_varchar2(hextoraw('D6A4C8AFCDB6D6')) from dual;          -- ORA-29275
select utl_raw.cast_to_varchar2(hextoraw('D6A4C8AFCDB6D6'))||'' from dual;      -- normal

Default: false

Option:

true
false