Utf-8 Collation

[son]

I have a from to upload data to a database. It has

header('Content-Type: text/html;charset=utf-8');mysql_set_charset($GLOBALS['DB'], 'utf8');

at the top.The database, the tables and fields are set toCollation: utf8_general_ciGerman special characters are stored for some reason as ASCII. ALthough they display fine on web pages: What else could be the reason that the database stores special characters as ASCII? What else could I check? I do not get it why it would do that and after research am at the end of my wisdom...Son

[justsomeguy]

Why is it a problem? The database doesn't necessarily store characters as ASCII, it just stores a string of bytes. The characters get messed up when something tries to parse that byte string as an ASCII string instead of a UTF string. It's still just a string of bytes though either way.

[son]

Why is it a problem? The database doesn't necessarily store characters as ASCII, it just stores a string of bytes. The characters get messed up when something tries to parse that byte string as an ASCII string instead of a UTF string. It's still just a string of bytes though either way.

Even when it is not an issue, what else could be there to try to parse the string as ASCII? The page that holds form is set to UTF-8 and so is database, table and relevant table fields. I really do not get it what else could be in there?Son

[justsomeguy]

Where are you seeing the characters print in ASCII?

[son]

Where are you seeing the characters print in ASCII?

Sorry for the mega late reply, I wasn't online for a long time (wasn't well for a while). I see it in PHPmyAdmin...Son