Question: Am I getting the ORA-29275
error on a SQL query. How can I find the affected rows
and how to I fix the data to remove the ORA-29275 error?
Answer: The oerr
utility gives us this information on the ORA-29275 error:
ORA-29275: partial multibyte character
Cause: The requested read operation
could not complete because a partial multibyte character was
found at the end of the input.
Ensure that the complete multibyte character is
sent from the remote server and retry the operation. Or read
the partial multibyte character as RAW.
The core issue of that the nls_chracterset values
for the multibyte character set does not match between
either two databases in a distributed query, or a query
where the webserver has a different character set.
There are several possible fixes for the ORA-29275 error,
all involving getting the NLS character sets to match:
1 - write a function to convert each row. Place this
function inside a PL/SQL function and call it for each row
of the table:
2 - If
you have a webserver, try setting the NLS_LANG environmental
variable on the webserver to american_america.al32utf8.
See MOS Note 69518.1 - Storing and Checking Character
Codepoints in an UTF8/AL32UTF8 (Unicode) database.
See MOS Note
788156.1 - AL32UTF8 / UTF8 (Unicode) Database
Character Set Implications
Oracle Training from Don Burleson
The best on site
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
is the registered trademark of Oracle Corporation.