Aces High Bulletin Board

Help and Support Forums => Aces High Bug Reports => Topic started by: Bizman on July 24, 2011, 02:33:30 AM

Title: AH Bulletin Board umlaut problem
Post by: Bizman on July 24, 2011, 02:33:30 AM: This is the closest forum by topic I could find to report this: For a couple of weeks now umlauted a and o have not shown properly. This is not only my problem, it has been documented to affect the whole Finnish AH community since July 16th. I suppose the same goes with the Swedes, Danes, Norwegians and Germans.

Or, dare I suppose, this is a conspiracy to force us to type in English also on our Squad Forums in case some Three Letter Organization wants to bypass the login passwords to spy our tactics in the next scenario? :noid
Title: Re: AH Bulletin Board umlaut problem
Post by: B-17 on July 24, 2011, 02:36:54 AM: Is that the two dots on top of some letters? :D
Title: Re: AH Bulletin Board umlaut problem
Post by: LThunderpocket on July 24, 2011, 02:55:12 AM: your right.they come up as question marks.alt+0252= ? (u with 2 dots) but it comes up as a ?
Title: Re: AH Bulletin Board umlaut problem
Post by: B-17 on July 24, 2011, 02:58:07 AM: ?
Title: Re: AH Bulletin Board umlaut problem
Post by: Bizman on July 24, 2011, 05:30:32 AM: Yep, it's about the dots. I just tested with the trema (http://en.wikipedia.org/wiki/Trema_%28diacritic%29) button on my keyboard, and it seems to affect all letters having double dots on them. Thus it affects even more languages, even English. Not to mention French, Turkish, Albanian... You name it.
Title: Re: AH Bulletin Board umlaut problem
Post by: RTHolmes on July 24, 2011, 08:57:45 AM: ?

thats strange, the forum and all the stuff behind it should be able to handle multiple character sets :headscratch:
Title: Re: AH Bulletin Board umlaut problem
Post by: 2bighorn on July 25, 2011, 01:10:51 PM: Looks like there's mismatch between doc charset (ISO-8859-1 aka Latin-1) and DB (UTF-8).
Title: Re: AH Bulletin Board umlaut problem
Post by: 2bighorn on July 25, 2011, 01:19:59 PM: Test: &euml
test:
Title: Re: AH Bulletin Board umlaut problem
Post by: Lusche on July 25, 2011, 01:22:56 PM: Noticed the same, also the degrees symbol doesn't display anymore.
Title: Re: AH Bulletin Board umlaut problem
Post by: RTHolmes on July 25, 2011, 01:29:45 PM: Quote from: 2bighorn on July 25, 2011, 01:10:51 PM
Looks like there's mismatch between doc charset (ISO-8859-1 aka Latin-1) and DB (UTF-8).

yeah I'd be looking at the char encoding in the MySQL tables, Ive had them change after reimporting tables and/or upgrading it. :old:
Title: Re: AH Bulletin Board umlaut problem
Post by: Tank-Ace on July 25, 2011, 02:57:49 PM: whoops, wrong topic.
Title: Re: AH Bulletin Board umlaut problem
Post by: The Fugitive on July 25, 2011, 03:45:40 PM: Quote from: RTHolmes on July 25, 2011, 01:29:45 PM
yeah I'd be looking at the char encoding in the MySQL tables, Ive had them change after reimporting tables and/or upgrading it. :old:

Well at least it isn't something that Skuzzy could screw up! :devil
Title: Re: AH Bulletin Board umlaut problem
Post by: RTHolmes on July 25, 2011, 05:20:22 PM: I couldnt possibly comment on that ... :uhoh
Title: Re: AH Bulletin Board umlaut problem
Post by: Noir on July 26, 2011, 06:48:51 AM: the euro symbol isn't working either

?
Title: Re: AH Bulletin Board umlaut problem
Post by: Skuzzy on July 26, 2011, 09:45:28 AM: Already checked the encoding Holmes. It is set to UTF8 and so is the board. Not sure what happened yet. Still trying to find the bug.

EDIT: Ahhhhh. It seems SMF has limited character set support for UTF8. I'll need to switch it, which is going to require some effort as they do not have a tool to undo UTF8 support. At least, not for the version we are running.

ëöĀĂ

Ok, see if it works now folks. A little hacking into the SMF source might do the trick.
Title: Re: AH Bulletin Board umlaut problem
Post by: RTHolmes on July 26, 2011, 10:01:24 AM: that sounds like a bit of a PITA to do :(

I just rechecked a couple of my own databases and one of them still has tables mysqlimport decided by itself to convert from utf8_general to latin1_swedish :bhead
Title: Re: AH Bulletin Board umlaut problem
Post by: Skuzzy on July 26, 2011, 10:23:04 AM: I appreciate the tip, it did point me in the right direction.

Why SMF would provide conversion to UTF8, but no function to revert is a bit puzzling.

Yes, I got bit my the conversion to latin1_swedish a while back on another database while migrating to a newer version of MySQL. Thankfully it was a small database with several small tables (no need to do the "copy to tmp" thing).
Title: Re: AH Bulletin Board umlaut problem
Post by: Noir on July 26, 2011, 01:33:46 PM: € test

edit: well done :aok
Title: Re: AH Bulletin Board umlaut problem
Post by: RTHolmes on July 26, 2011, 02:55:34 PM: Ĝŏőđ Ĵôþ! :D
Title: Re: AH Bulletin Board umlaut problem
Post by: Krupinski on July 26, 2011, 02:57:48 PM: wööt!
Title: Re: AH Bulletin Board umlaut problem
Post by: Lusche on July 26, 2011, 05:19:13 PM: Der fürchterliche Mörder rührte ächzend mit Mühe Sahne grüner Kühe bei 8° Celsius. Was für ein Stuß!

Works :D :aok
Title: Re: AH Bulletin Board umlaut problem
Post by: 2bighorn on July 26, 2011, 05:21:55 PM: Quote from: Skuzzy on July 26, 2011, 10:23:04 AM
Why SMF would provide conversion to UTF8, but no function to revert is a bit puzzling.

Because back conversion is lossy and also because all new HTML standards are based on unicode.
Title: Re: AH Bulletin Board umlaut problem
Post by: B-17 on July 26, 2011, 10:51:05 PM: ü WTG HTC
Title: Re: AH Bulletin Board umlaut problem
Post by: LThunderpocket on July 26, 2011, 10:59:42 PM: Quote from: Lusche on July 26, 2011, 05:19:13 PM
Der fürchterliche Mörder rührte ächzend mit Mühe Sahne grüner Kühe bei 8° Celsius. Was für ein Stuß!

Works :D :aok

out of all things you could've said in deutsch...
Title: Re: AH Bulletin Board umlaut problem
Post by: Tank-Ace on July 26, 2011, 11:05:33 PM: Not to expose my ignorance, but how do you use the umlaut, and other accents?
Title: Re: AH Bulletin Board umlaut problem
Post by: LThunderpocket on July 26, 2011, 11:08:22 PM: Quote from: Tank-Ace on July 26, 2011, 11:05:33 PM
Not to expose my ignorance, but how do you use the umlaut, and other accents?

alt codes
Title: Re: AH Bulletin Board umlaut problem
Post by: Tank-Ace on July 26, 2011, 11:11:46 PM: ummmmm....... yeah, I'm not that forum savy :aok.
Title: Re: AH Bulletin Board umlaut problem
Post by: B-17 on July 26, 2011, 11:12:45 PM: Alt+0252=ü
Alt+130=é
Alt+0232=è

Don't remember any more :P
Title: Re: AH Bulletin Board umlaut problem
Post by: Tank-Ace on July 26, 2011, 11:14:31 PM: Can I get a list please :(?
Title: Re: AH Bulletin Board umlaut problem
Post by: B-17 on July 26, 2011, 11:16:28 PM: Google them. Or look them up in Microsoft Word.
Title: Re: AH Bulletin Board umlaut problem
Post by: B-17 on July 26, 2011, 11:17:43 PM: Here you go... Aren't I just Mister Nice Guy tonight :devil

http://www.tedmontgomery.com/tutorial/altchrc.html
Title: Re: AH Bulletin Board umlaut problem
Post by: Tank-Ace on July 26, 2011, 11:18:57 PM: Yay!!! I'z can types!
Title: Re: AH Bulletin Board umlaut problem
Post by: LThunderpocket on July 26, 2011, 11:41:56 PM: Quote from: Tank-Ace on July 26, 2011, 11:18:57 PM
Yay!!! I'z can types!

the diaper commercial comes to mind.."im a big boy now"
Title: Re: AH Bulletin Board umlaut problem
Post by: Bizman on July 31, 2011, 05:44:32 AM: Thänks! It seems to wörk nöw! WTG :salute

Long threads still have strange markings instead of umlauts in messages that have been typed during this episode, but it's a thing one can live with.