Hi Guys

I have a user who wants to update an online MySQL database I set up with an uploaded SQL script at irregular intervals.

A self-developed CMS written in PHP displays the database contents.

The problem is his SQL script contains ISO specified characters - it has several German and Swedish / French names in it, like "Luttichau" (with an umlaut on the first "u") and "Marie" (with the grave accent on the last "e")

How can I automatically encode these ISO characters to HTML in the LAMP environment?

I. e. turn "Luttichau" (umlaut "u") into "L¨ttichau" (ISO to HTML)

Presently I do this manually by taking his script and running it through an Emacs LISP script I found called "iso2html" which works just fine. Obviously though, I would prefer this to happen automatically on the server, as I'm not always around 23:15 on a Sunday night when he wants to update his data...

Doesn't PHP have tons of classes and modules already doing this stuff? I know that Perl has and I simply can't imagine PHP doesn't.

If you REALLY want to do this all by yourself, grab the iso-8859-1 value of the char and wrap it into &#thevalue;. In this lower byte ranges, the iso-8859-1 value is identical to the Unicode code point - just add leading zeros.

Meaning: What is (hex) C4 in man iso-8859-1 (Ä) is 00C4 in Unicode and &#x C4; in HTML. (Spaces for visualization here - remove.)

See this handy table: http://en.wikipedia.org/wiki/List_of...ity_references

and check man iso-8859-1 and man unicode.

A simple dispatch table will also do the trick.