Ducati Monster Forum

Kitchen Sink => Board Tech Issues => Fixed Board Issues => Topic started by: Drunken Monkey on September 20, 2008, 10:22:47 AM

Title: Character encoding issue?
Post by: Drunken Monkey on September 20, 2008, 10:22:47 AM
I've noticed a fair number of older posts now have garbage characters in favor of unicode characters

i.e.
Quote
now, you may have seen news in other publications of the forthcoming Ducati Hyperfighter that's allegedly scheduled for a 2008 EICMA debut. The thing is, the machine is a total work of fiction. Created by conceptual artist Oberdan Bezzi for his site Motosketches, the Hyperfighter envisions what a hypothetical future 1098/Hypermotard hybrid might look like. As usual â€" we're big fans of Oberdan's work â€" the concept is full of clever ideas that come together to create a really good-looking bike. Presented alongside a fictional timeline for its development and a description of its technology â€" sort of an imaginary brief for the concept â€" we understand why people want to believe in it. The confusion seems to arise from a reader comment Oberdan left on MCN's website. Their commenting system is confusing, giving equal precedence to content created by both the publication and its commenters, which has led to several other websites reporting on the Hyperfighter as actual news. But honestly people, apply some critical thinking to things.

Not sure if this was already an existing problem, but I've really only noticed it post new server.

I know, this is a weak sauce bug report, but I just thought I'd mention it.
Title: Re: Character encoding issue?
Post by: Drunken Monkey on September 20, 2008, 10:57:43 AM
Even seems to have affected the BOMB entires:

QuoteThis is Celli's second Monster.

Weird.


Title: Re: Character encoding issue?
Post by: DarkStaR on September 20, 2008, 10:59:55 AM
Seems like it's just "quotation" marks and 'apostrophes'.
Title: Re: Character encoding issue?
Post by: darylbowden on September 20, 2008, 11:16:07 AM
Seems like SQL isn't properly escaping certain characters for some reason.  Lemme take a look and see what I can do about it.
Title: Re: Character encoding issue?
Post by: darylbowden on September 20, 2008, 11:19:41 AM
Hmm, there might not be anything that can be done about this.  Some old posts are affected and some aren't.  I'm thinking that something happened during the mysqdump from the old db that didn't escape certain characters properly.  I'll try and look into it some more, but we might just have to live with it.
Title: Re: Character encoding issue?
Post by: ducpainter on September 20, 2008, 11:23:20 AM
IMO, if that's the worst thing that happened in this it's a non issue...

but that's just me.
Title: Re: Character encoding issue?
Post by: darylbowden on September 20, 2008, 11:39:41 AM
Quote from: ducpainter on September 20, 2008, 11:23:20 AM
IMO, if that's the worst thing that happened in this it's a non issue...

but that's just me.

I agree.  I've actually only found one post so far that has been affected (I'm sure there's others), but overall I don't think anyone will lose any sleep over it.
Title: Re: Character encoding issue?
Post by: Drunken Monkey on September 22, 2008, 11:56:18 AM
Yeah, as long as it's fixed for posts going forward, no biggie.
Title: Re: Character encoding issue?
Post by: bigiain on September 23, 2008, 02:24:55 AM
Quote from: darylbowden on September 20, 2008, 11:19:41 AM
I'm thinking that something happened during the mysqdump from the old db that didn't escape certain characters properly.

Errrmmm, let me guess, this upgrade crossed over the MySQL4.0 - MySQL4.1 versions?

Gah! (_There's_ some grief I didn't need to remember...)

big
Title: Re: Character encoding issue?
Post by: ducpainter on September 23, 2008, 04:13:43 PM
Quote from: bigiain on September 23, 2008, 02:24:55 AM
Errrmmm, let me guess, this upgrade crossed over the MySQL4.0 - MySQL4.1 versions?

Gah! (_There's_ some grief I didn't need to remember...)

big
new server does use an updated version....