[Known Issue] Pound signs come out as question marks

[Ronin Storm]

Various people have noticed over the past week or two that when they type a GB Pound sign it in fact prints as a question mark.

The problem, we believe, is because of a mixture of the database encoding and its current collation settings. No, I can't explain that further because that's right at the edge of my MySQL database knowledge.

For the moment, it's the way it is.

Unfortunately, we need to be damn sure of what we're doing before we just dive in and "fix" it because we're faced with one giant risk... let's say we switch how it is all encoded, but then it trashes all our data... that's pretty serious, yes?

Please bear with it for the time being. I suggest a workaround of typing GBP instead of the symbol. Sorry for the inconvenience.

 

[T-Bone]

Also the ? or shift + ` shows up as ?'s also. Or at least they do in the shoutbox.

 

[Ronin Storm]

Hmm... tilde too?

~

Ah, no... the tilde key is one that wanders around from keyboard to keyboard. On mine it's the shift-backtick that would give a square hooked line.

?

 

[elDiablo]

The key with ascii code 170 (shown on this page) comes out as ?s.

 

[T-Bone]

Sorry my bad, see my edit.

 

[Pestcontrol]

Euros are buggered too. It feels like it's defaulting to 7-bit ASCII here.

UTF-8 Uber alles!

 

[Ronin Storm]

Ah, bugger. They were working in the shoutbox not too long ago.

 

[Gopha]

Its like they are trying to destroy currencies, watch out Dollar!

 

[KillCrazy]

???????????????????????

Hmmm....weird. They show up when you preview the post but I'm guessing it's not interacted with the database until you actually post it or something.

 

[Ronin Storm]

it's not interacted with the database until you actually post it

Yep, that's about the shape of it.