In This Thread Krylo Talks About Games He's Currently Playing

[synkr0nized]

Originally Posted by Krylo

?????????

Edit: Forgot the forums don't have support for chinese/japanese characters.

Guess that was pointless then.

???????

---------- Post added at 11:03 AM ---------- Previous post was at 11:02 AM ----------

Interesting.

That showed up fine in the "preview post", but turned into all ? after posting.

My assumption is that one of our modifications -- at present I am assuming the dice roller -- has gone through the post looking for something and stripped the proper encoding as a result.

---------- Post added at 11:04 AM ---------- Previous post was at 11:03 AM ----------

Nope, that wasn't it. Herp derp, probably because the preview is handled without actually doing anything to the thread/interacting with the database. Hell it might even be cached locally in your browser client only. I forget.

---------- Post added at 11:41 AM ---------- Previous post was at 11:24 AM ----------

Right, so our database is still rockin' out with "Latin1" encoding instead of UTF-8 (for vBulletin; AJAXChat's tables use UTF-8), so when you actually make a post it's getting stored in the database with a character encoding that doesn't handle foreign languages.

Someone remind me to all official-like make a post in the appropriate section to inform people that I'll lock the forum down temporarily, back up the database, and convert it to UTF-8 globally. And then do that at some point with minimal disruption to you all. Because that's silly in the modern Internet world to not support multiple languages when it is possible.

---------- Post added at 11:58 AM ---------- Previous post was at 11:41 AM ----------

screw it, doing it in ~8 minutes from now

---------- Post added 05-08-2014 at 01:01 AM ---------- Previous post was 05-07-2014 at 11:58 AM ----------

also when I was working on this I caused a process on the server to hang that broke the connection to the database and, thus, the site for the day

sorry about that :/

I will legit work on this a more correct way another day.