Kbase P146845: Oracle DataServer: Korean characters are displayed as question marks in 4GL session
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/05/2009 |
|
Status: Unverified
SYMPTOM(s):
Korean characters are displayed as question marks in 4GL session
SQL*Plus session on UNIX server displays Korean characters as question marks
FACT(s) (Environment):
4GL client on Windows XP is connected to a schemaholder database using -cpinternal CP949 and -cpstream CP949
Client is using startup.pf which is a copy of %DLC%\prolang\kor\korean.pf
Schemaholder database created as a copy of %DLC%\prolang\kor\empty database
Oracle DataServer and Oracle instance reside on the same UNIX server
SQL*Plus session on Windows XP displays correct Korean characters
Progress 4GL client is running on Windows XP
Support for East Asian Languages is enabled on the Windows XP client (Regional and Language Options, Languages tab, on Windows XP Settings/Control Panel))
Fonts for Korean characters are installed on the Windows XP client
Language for non-Unicode programs is set to Korean (Advanced Regional and Language Options in Windows XP)
Progress 9.x
UNIX
Oracle
CAUSE:
The user account used to start the Oracle DataServer broker ($DLC/bin/_probrkr) was missing or had the incorrect value for the NLS_LANG environment variable.
FIX:
Ensure that the NLS_LANG environment variable associated with the user account starting the Oracle DataServer broker contains the correct values for language_territory and charset (NLS_LANG=language_territory.charset) . In this case setting NLS_LANG=KOREAN_KOREA.KO16MSWIN949 solved the problem. Note that the Oracle DataServer broker needs to be restarted after adding or modifying the NLS_LANG environment variable.