MySQL Problem with Umlauts

Question

i have a big problem with umlauts. I have a normal registration Form. And when i click on Submit, i send the data via jQuery Ajax to a php Script. This Script puts everything in my database.

The Database Collation is utf8_general_ci but the umlauts are displayed like crap :D When i submit a new User to that database in the backend, where only php plays it works with umlauts.

Where is my fault? Can´t figure it out.

Thanks :)

@Tyler: I seriously doubt Jings meant excrement. A smiley rendered with the wrong character encoding might look like this: â�ş (copied and pasted from Aptana, which has a char encoding problem). It definitely looks like crap. — mingos
– mingos, Commented Dec 9, 2010 at 18:40
@mingos: I hardly think an accurate description of erroneous output is too much to ask for. Yes, it likely is an encoding issue, but who really knows when OP doesn't give nessesary info. — Tyler Eaves
– Tyler Eaves, Commented Dec 9, 2010 at 18:41
Linguistic laziness on the OP's part is a fact, I can't argue with that. But let's not push this too far: "like crap" is a very common manner of describing something as "bad, erroneous", for me it's as precise as it gets when dealing with mangled non-ascii character output (with which I deal often, as my language has a myriad of such characters). — mingos
– mingos, Commented Dec 9, 2010 at 18:46

jwueller · Accepted Answer · 2010-12-09 18:42:48Z

2

Make sure that you're using UTF-8 everywhere in that chain. Your page needs to be encoded in UTF-8, so that the browser submits the user-data correctly. Check the Content-Type header of the request. Your webserver should deliver the MIME-type with ; encoding=UTF-8.

answered Dec 9, 2010 at 18:42

jwueller

31.1k5 gold badges69 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Problem with Umlauts

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related