Kbase P100047: Does Progress DataServer for Oracle support UTF-8?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/2/2009 |
|
Status: Verified
GOAL:
Does Progress DataServer for ORACLE support UTF-8?
GOAL:
Does DataServer for ORACLE support Unicode?
GOAL:
How to handle Oracle UTF-8 code page (Unicode)
FACT(s) (Environment):
OpenEdge 10.x
Oracle DataServer
All Supported Operating Systems
FIX:
DataServer for ORACLE does provide Unicode support starting with OpenEdge 10.1C and later.
Refer to the OpenEdge 10.1C manual, DataServer for Oracle, for information about how to configure the DataServer to support Unicode.
Unicode is not supported in versions of Progress / OpenEdge lower than 10.1C.
However the DataServer for ORACLE can support double-byte characters so long as the ORACLE DBMS is set up for Native Language Support (NLS). In versions of the Progress Oracle DataServer that do not support Unicode, Oracle needs to makes the conversion by having its Call Interface (OCI) client code page set to match the Progress code page. For example, if the Progress code page used is ISO8859-15 then NLS_LANG can be set to AMERICAN_AMERICA.WE8ISO8859P15. For more information on NLS, see the ORACLE documentation.