Hi Dossy, It appears that I've found the problem. As I said previously, the original database was using US7ASCII, and the new database is using UTF8. Users who were using the online ACS forms to upload data were importing text formatted by Microsoft Word, which placed smart tags in the text as well, changing the character encoding in parts from pure US7ASCII to LATIN1, I think. In any case, we were just lucky with the original database that the data was not being displayed with funny characters by most browsers. But obviously this editorial flaw has been exposed by the new database charset.
Kind Regards, Gabriel >From: Dossy <[EMAIL PROTECTED]> >Reply-To: AOLserver Discussion <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: [AOLSERVER] gfb: language encoding issue >Date: Fri, 30 Nov 2001 14:21:08 -0500 > >On 2001.11.30, gf b <[EMAIL PROTECTED]> wrote: > > Originally the database was exported from an Oracle 8.1.7 database using > > US7ASCII, and now we're using an Oracle 8.1.7 datbase set to use UTF8. >I've > > set NLS_LANG=AMERICAN_AMERICA.UTF8, but this has'nt changed anything. >Also I > > don't think there has been any corruption of data during encoding >conversion > > during the export. > >Have you run your queries through SQL*Plus? Does it display your >data as expected? > > > Can I specifically enter some parameters in the tcl startup script that > > would be able to interpret data pulled out of the database in UTF8, and > > delivered to the browser as US7ASCII; or would we have to change the > > encoding scheme on the database? > >Not sure. There are people better versed in i18n than I am on >this list -- I hope one of them will answer. > >-- Dossy > >-- >Dossy Shiobara mail: [EMAIL PROTECTED] >Panoptic Computer Network web: http://www.panoptic.com/ > "He realized the fastest way to change is to laugh at your own > folly -- then you can let go and quickly move on." (p. 70) _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
