AS=>PHP=DataBase encoding problem

[bmerens]

hello,

I have on my website a formular which sends its data to my database via a pho script.

everything works fine except for words like "ù à è é ...." french and german letters like ü ä....etc

I tried to encode the data with rawurlencode or utf8_encode but still the same prob, the database can't read the letters ü,é,à...etc

is it possible to encode the data within AS? it seems to me the only solution....or not? :ponder:


something else, I ha ve a php script which takes from my DB data containing letters like é,è...etc...and before sending it to AS I encode it with utf8_encode and this wokrs really fine.


any suggestions?

[ghjr]

If you echo it in your PHP script (before inserting into the database) does it come out correctly?

[bmerens]

I can add an echo to my php script, but the AS uses sendvar.sendAndLoad("http://www. to call the php script.

it doesn't open the php page. I cant't see the echoed variable

[ghjr]

Maybe setting this on the PHP file header might help:
<meta http-equiv="content-type" content="text/html;charset=UTF-8">

I don't think performing htmlspecialchars() on the string before inserting would help out at all in this case (since I don't think those are considered html special characters), but you might give it a try.

Cheers!

[Dutchy]

Have you tried:


system.useCodepage = true;

maybe that will help,
Dutchy

[bmerens]

that's it

thanks a lot :) :) :)

[bmerens]

but this solution brings a new problem :

my php script sends an automatic email, containing french and german characters, to the customer. before I switchen the UseCodePage to true , the email schowed the french and german characters properly

but now, as the UseCodePage is true, the automatic email doesn't recognize the french/german characters anymore.

what can I do now I dont' understand all these encoding problems hopless