[Zope] International character display from Oracle database

Dominic Hiles Dominic.Hiles@bristol.ac.uk
Tue Aug 5 17:22:28 EDT 2003


Hi,

I am using Zope on Linux, front-ended by Apache, to retrieve data from an 
Oracle 8.1.7 database via DCOracle2: 1.3 beta. I have setup the NLS_LANG 
environment variable in both Zope & Apache to be "ENGLISH_UNITED 
KINGDOM.UTF8" (ref. 
<http://mail.zope.org/pipermail/zope-db/2003-February/001482.html>) and 
NLS_CHAR="UTF8". The source data are correctly held within the Oracle 
database, since these data have been successfully displayed via ODBC and 
JDBC drivers on other platforms.

However, when retrieving the data using the above configuration, Greek 
characters are replaced with question marks (which can be verified as 
simple question marks in the page source).  Has anyone else experienced 
this problem?

Any help would be much appreciated!

Many thanks,

Dominic






More information about the Zope mailing list