KNOWLEDGE BASE

Error "ORA-29275: partial multibyte character" When Extracting or Viewing Data


Published: 08 Jan 2015
Last Modified Date: 21 Jan 2017

Issue

When extracting or viewing data from an Oracle database, the following error might occur: 
 
ORA-29275: partial multibyte character.

Environment

  • Tableau Desktop 
  • Oracle

Resolution

Remove from the Oracle database any characters that are not encoded in UTF-8. The line number referenced in the error message should correspond with the non-UTF-8 character.

Note: Tableau Desktop 8.1.11, 8.2.4, and later versions include updated error messaging that will display the name of the column containing the data that has caused the error. For more information about upgrading, see Upgrading Tableau Desktop.

Cause

This error occurs when Oracle doesn't know how to convert certain characters in your data.
Did this article resolve the issue?