ORA-29275: partial multibyte character with 11.1.0.7
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
SQL> create table test_char(c1 varchar2(100));
Table created.
SQL> insert into test_char values (chr(200));
1 row created.
SQL> select from test_char;*
ERROR:
**ORA-29275: partial multibyte character**
NLS_CHARACTERSET ==> AL32UTF8
But, with Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
Don't throw any error
SQL> select * from test_char;
C1
--------------------------------------------------------------------------------
question is what is the reason behind throws this ORA-29275 and how to work around or suppress this error in 11.1.0.7(similar to 9.2)