International character display from Oracle database
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
Dominic Hiles wrote:
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?
Are you setting the correct character encoding in your HTML? cheers, Chris
Hi Chris, The problem seems to be happening before the content is rendered on the page, rather than being related to the page presentation - I can add the correct characters as plain text on the same page without any issues. Cheers, Dominic --On 06 August 2003 12:39 +0100 Chris Withers <chrisw@nipltd.com> wrote:
Dominic Hiles wrote:
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?
Are you setting the correct character encoding in your HTML?
cheers,
Chris
Dominic Hiles wrote:
The problem seems to be happening before the content is rendered on the page, rather than being related to the page presentation
Hmmm, how have you established this? Unicode errors seem to be fiendishly difficult to track down as python will, by default, try to encode to ASCII when you just print something to a console. Likewise, if you're doing a SELECT in the test tab of your DA, what encoding does the HTML page that contains have? If you're testing it using other means, think about any possible encoding or decoding going on during the testing process :-S *sigh* Why can't be just all have one character set ;-) Chris
participants (2)
-
Chris Withers -
Dominic Hiles