Funny DB characters

[DarkRanger]

I have a character in the database ö that returns as �.

Is there any way I can fix this? I'm using php5 and MySQL.

It's supposed to read Dölling and not D�lling

[SykomantiS]

What char-set are you using? Should be utf8 from what I can gather from Google?

[DarkRanger]

Yeah that's what I saw on google as well.

Changed it to utf8_bin because that's the closest to utf8 that phpmyadmin offers...

[DarkRanger]

any help??

[doo_much]

As a matter of interest DR - where is the � returned?

[DarkRanger]

After coming from the DB. In the database itself it reflects as the o with the kolletjies on.

In my header I've also set the page to utf8

[Tribble]

And it is a fontset that your PDF program has?

[doo_much]

No - what I mean is where are you viewing it as � ?

If the database "reflects [it] as the o with the kolletjies on", then whatever you are using to view it that shows the funny character must be at fault?

[Bladerunner]

"o with the kolletjies on"

Umlaut O.

[doo_much]

Wisedonkey...

[DarkRanger]

doo, I don't understand exactly what you mean.

It's in a php page that is being called by ajax. It basically loads the employee list from the DB and then displays it. There where it is displayed in the page it displays as hat funny character.

[doo_much]

What I mean is that if the "Umlaut O" (thanks Blade) i OK in the database, then obviously whatever you are using to view it is fubar?

And since you're using php I'm assuming there's a stylesheet involved somewhere? And maybe whatever font is specified in there doesn't support the "Umlaut O"?

As I said - merely guessing and assuming here...

[DarkRanger]

I'm using verdana... Pretty sure it supports it...

Anyhow, I've decided to parse weird characters out and just show them without any umlauts...