Get - php - MySQL: trouble with Nordic alphabets

[MJK]

I'm using the Get object to send data to MySQL database through a php script. When I run it from MMF2, everything works fine. But when compiled to swf, it fails to send Nordic alphabets Ä, ä, Ö, ö (A with two dots above, O with two dots above) to the database. Basically if player name contains one of these letters, it doesn't send any data at all. Then again when I test it inside MMF2, everything goes through no matter how many Nordic characters are used.

Any ideas?

[James]

Is this POST data or part of the URL?

[MJK]

It's part of the URL, i.e. Get "http://domain.com/sendscore.php?name="+Edittext$("name")+"&score=" and so on...

[James]

Try sending it as POST data.

[MJK]

Now it seems to work. Thanks! So is there any reason to use the URL embedded way anymore to send stuff to db or is "Post" always a better option?

[Dynasoft]

As per the HTTP spec POST should be used when making changes, GET when making queries/requests.

[Fanotherpg]

MJK I believe that it's more problem that still web addresses have got problems with accepting not latin characters. It is slowly corrected but still you would have to change them on special character sets like "space" to "%20"...

[LB]

Maybe the URL encoder supports this? I have't tried.

[James]

If that's the case, the Get object has an URL encode expression in the latest version.

[MJK]

OK, thanks guys. I think I'll keep using POST for now as it seems to work nicely.