Seeing Inverted Question Marks with Oracle

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

  1. Random inverted question marks appear replacing quotation marks/hyphens copied from a Microsoft Windows document. For example:

    Jeremy¿s going to buy me a surprise gift and I¿m going to act surprised.
    
  2. Using Oracle with non UTF8 encoding, eg. WE8ISO8859P1 ISO 8859-1 West European
  3. No error recorded in the log file

診断

Failed the Database Round-trip test in the Database Encoding test. Also you can execute this query to check which is the current database character set:

select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

 

原因

Some of the characters used by Windows are not covered by the database encoding (eg. WE8ISO8859P1).

ソリューション

Switch to an Oracle encoding that supports Windows characters. eg. AL32UTF8 (Confluence 5.5 or later versions) or WE8MSWIN1252 (Confluence 5.4 or earlier versions). You can refer to oracledba.co.uk for tips on how to change the characters.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

最終更新日 2017 年 11 月 27 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.