Error: 'ORA 29275 partial multibyte character' shows in Schema Browser Data tab when there are extended ascii characters stored in the table (4243567)

Error: 'ORA 29275 partial multibyte character' shows in Schema Browser Data tab when there are extended ascii characters stored in the table

When selecting from a table with extended ascii characters stored within it, or when going to the Schema Browser | Data tab, the following message is shown:

'ORA 29275 partial multibyte character'

By design due to unicode functionality.

The message appears becasue of incompatibility between the unicode environment and extended ascii characters. Toad can retrieve the unicode version of the character with no error.

The easiest way to reproduce this error is if you run in the Editor: "select chr(191) from dual;"

You can select that same character with no error if you use the unicode version of it, and run: "select '┐' from dual;"

You can see the difference between the two with "select dump(chr(191)), dump('┐') from dual;" command.