Kbase P106696: Accentuated characters display incorrectly in SQL*Plus
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Using DataServer/ORACLE Utilities/Run ORACLE SQL*Plus... from Progress Data Administration
Some characters display incorrectly in Oracle
ASCII value the same in Progress and in Oracle
4GL "disp asc(substring(name,2,1))" is the same as SQL "select ascii(substr(name,2,1)) from ...", for example
CAUSE:
The charset for the character SQL*Plus session does not match the GUI code page.
FIX:
1. type "Ctrl-C" from SQL*Plus, to stay in the DOS window but out SQL*Plus
2. set the variable NLS_LANG to a value compatible with the NLS_LANG from GUI Oracle
for example, if Oracle registry shows NLS_LANG to DUTCH_THE NETHERLANDS.WE8MSWIN1252, run:
set NLS_LANG=DUTCH_THE NETHERLANDS.EE8PC852
3. start SQL*Plus again by typing "sqlplus"