A suggestion concerning special chars (eg. umlaut)

[joximu]

Hi
there is an open tickets dealing with characters outside of ascii - #915.

It turns out hat most of the texts which are put in the forms are converted to html code which checking the input itself.
Raphael did some improvements to be able to skip the coversion to html - but it really looks like almost all text fields may containe umlauts/special characters.
As long as the texts are only used for HTML output the conversion is ok, but in emails and javascripts there is no use for ä for example...

So: my suggestion: always skip the conversion to html
input-checks.php: function clean_input($input, $htmlencode = false)
so the special characters are put directly (as-is) into the database.

This works good in my new installation... all mails are ok, names, texts

Another thing: pma uses only utf-8 as character set. It seems that the database with ispcp still uses latin1(_swedish) for various texts - even if the db, tables and fileds are utf-8 "collated"....
With an
@$sql->Execute("SET NAMES 'utf8'");
just after the @$sql->connect in sql.php we force every mysql connection to use utf8 - and then we can see the right umlaut we put in...

(for updaters: the language file has to be uploaded again, and the email tpl texts... - and of cours all the names of the customers... - but it should be able to handle this...)

Your comments...???

/Joximu