熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

ORACLE在HP-UX下的系列問題處理(16)

2013-11-13 16:05:19  來源: Oracle 

  NLS法文字符顯示不正確問題描述
  
  我用下面的SQL(結構化查詢語言)查詢語句從Oracle數據庫中檢索數據
  macdev::/mac/HAHTsite [ ] >more tsql
  select * from tmpbo where no_inf_ad = ;
  我運行查詢語句將輸出發送到文件中
  sqlplus www/www < tsql > t
  
  在該文件上執行more命令時法文字符出現亂碼當我在同一個文件上執行cat時字符顯示正常
  
  如何解決這個問題?
  
  配置信息
  
  操作系統 HPUX
  版本
  硬件系統 PA
  系列 D
  應用程序 Oracle
  
  解決方法
  
  你可以用下面的腳本打開一個本地hpterm窗口解決這個問題本地hpterm窗口允許你顯示Oracle數據庫的輸出
  
   #!/bin/ksh
   # Open a hpterm to use isofrench:
   LANG=fr_FRiso
   export LANG
   hpterm xrm *keyboardLanguage: French fn bitstreamprestigemediumrnormalmiso
  由於Oracle輸出中沒有顯示控制字符因此你應當能夠顯示Oracle數據庫的輸出
  following with all English text
  Problem Description
  
  I am retrieving data from an Oracle database with this SQL (Structured
  Query Language) query:
  macdev::/mac/HAHTsite [ ] >more tsql select * from tmpbo where no_inf_ad = ;
  I run the query to send the output to a file:
  sqlplus www/www < tsql > t
  When I do a more on that file the French characters are garbled When I do a cat on the same file the characters display as they should
  How can I resolve this problem?
  Configuration Info
  Operating System HPUX
  Version
  Hardware System PA
  Series D
  Application Oracle
  Solution
  You can resolve your problem by using the following script to open a localized hpterm window The localized hpterm window allows you to display your output from the Oracle database
  
   #!/bin/ksh
   # Open a hpterm to use isofrench:
   LANG=fr_FRiso
   export LANG
   hpterm xrm *keyboardLanguage: French fn bitstreamprestigemediumrnormalmiso
  Since there are no display control characters in the Oracle output you should be able to display your output from the Oracle database
  
  
  
  
  
  
  

From:http://tw.wingwit.com/Article/program/Oracle/201311/17788.html
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.