Oct 19

ORA-29275: partial multibyte character tips(FROM WEB) 不指定

admin , 20:44 , 数据库 » 数据库(Oracle管理) , 评论(0) , 引用(0) , 阅读(533) , Via 本站原创 | |
我已经获得阿里云幸运券,准备分享给您。请点击获取   ORA-29275: partial multibyte character tips(FROM WEB) http://www.dba-oracle.com/t_ora_29275_partial_multibyte_character.htm

                  Oracle Database Tips by Donald BurlesonJuly 13, 2015



          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.

Action:           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

Tags: ,