On Thu, Jun 15, 2006 at 01:04:58PM +0200, Erik Baluba wrote: > Hi Øyvind, > ... > >I have data in an Oracle 10gR2 database in ISO-8859-1 encoded columns > >(WE8ISO8859P1) and the names of my geometries appear correctly in a > >sqlplus search. But on the test mapserver PNG all characters beyond > >decimal 127 (such as æøå) come out as '?'. > > What is the NLS_LANG setting on the oracle client computer running your > webserver? If it is a Norwegian or English Windows the codepage is WIN1252 > and your NLS_LANG would be something like Norwegian_Norway.WE8MSWIN1252. If > so I see nothing wrong with your setup because character encodings for > 'æøå' are the same in both ISO-8859-1 and WIN1252. Still, you can try to > set the ENCODING to CP1252 in your mapping file to see if it helps.
Thank you Eric! The web server is running on a RHEL linux box. By adding the line SetEnv NLS_LANG "norwegian_norway.we8iso8859p1" to the apache conf file (in our case an extra httpd.conf file read after all the standard ones), the character set was fixed! Kind regards, Øyvind Eide
