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

Published: 08 Jan 2015
Last Modified Date: 20 Jun 2017


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


  • Tableau Desktop 
  • Oracle


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 Upgrade Tableau Desktop.


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