Database Administration (MOSC)

MOSC Banner

questions about character sets and partial multibyte characters

characterset = AL32UTF8


SQL > select chr(240) from dual;

ERROR:

ORA-29275: partial multibyte character


SQL > create table dummy (a char(1));


Table created.


SQL > insert into dummy values (chr(240));


1 row created.


SQL > commit;


Commit complete.


BANDEV_SQL > select * from dummy;

ERROR:

ORA-29275: partial multibyte character


Why is hex a0 considered a partial multibyte character? Why would Oracle allow a partial multibyte character to be inserted into a column?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center