Diacritics not appearing on web site ....

[James]

I have an application that I have sold to a few institutions and one
installation in particular is giving me a real headache. Its a PHP
application that draws data from either Oracle or MySQL - much of the
data contains characters with diacritics (â à etc). It has been
installed on a range of webservers and php versions and operating
systems yet this time the diacritics are being removed -- â will
simply be displayed as a.

We have double checked the data in the database and it does contain
these characters -- somewhere between Unix, Apache and PHP these are
being converted and I do not understand where. Its not my script - we
tested with a plain cut and paste script from php.net on MySQL and the
same thing. I also made sure the characters where not in the
underlying html and they are not.

Help --

System SunOS knot 5.8 Generic_108528-12 sun4u
Apache Version Apache/1.3.33 (Unix) PHP/4.3.10
OCI8 Support enabled
Revision $Revision: 1.183.2.16 $
Oracle Version 9.2

I have the full phpinfo generated contents - if there are things I
should check please let me know.

[Andy Hassall]

On 24 Feb 2005 08:36:53 -0800, "James" <st******@gmail.com> wrote:

I have an application that I have sold to a few institutions and one
installation in particular is giving me a real headache. Its a PHP
application that draws data from either Oracle or MySQL - much of the
data contains characters with diacritics (â à etc). It has been
installed on a range of webservers and php versions and operating
systems yet this time the diacritics are being removed -- â will
simply be displayed as a.

We have double checked the data in the database and it does contain
these characters -- somewhere between Unix, Apache and PHP these are
being converted and I do not understand where. Its not my script - we
tested with a plain cut and paste script from php.net on MySQL and the
same thing. I also made sure the characters where not in the
underlying html and they are not.

Help --

System SunOS knot 5.8 Generic_108528-12 sun4u
Apache Version Apache/1.3.33 (Unix) PHP/4.3.10
OCI8 Support enabled
Revision $Revision: 1.183.2.16 $
Oracle Version 9.2

I have the full phpinfo generated contents - if there are things I
should check please let me know.

If this is coming from Oracle, what's your NLS_LANG environment variable set
to?

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool