I've had a bad night sleep over this... Can't figure out where it goes wrong.
in a form, the user is entering a field with e.g. "åäö" ,
so the characters enter the php page like "%C3%A5%C3%A4%C3%B6" so far so good.
to insert this in the mysql database the php script translates this back with urldecode() (also tried rawurldecode) as far as i can see, the query send to the database contains the carachters "åäö" again. This is also as expected.
Now for the fun part;
when ik look in phpmyadmin what data is saved in the table i see:Ã¥Ã¤Ã¶ as a value. NOT AS EXPECTED and certainly not wanted ;) if i display the table values in the front-end HTML page it also displays as: Ã¥Ã¤Ã¶.
As far as i can see my database, tables and fields are encoded "latin1_swedish_ci"
now, where does this go wrong?