Oct 19

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

admin , 20:44 , 数据库 » 数据库(Oracle管理) , 评论(0) , 引用(0) , 阅读(210) , Via 本站原创 | |
怎么手机十秒时时监控          拍拍购物综合频道 正品1折起 惊喜多多      拍拍女装特卖频道,汇集了最新的女装时尚新款 正品1折起,爱美的我还在等什么
     手机访问 就能天天 特价     电脑访问 爱淘宝go 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: ,