Board index Public Relations Site Related Database and special characters

Database and special characters

Posts that are directly related to the site.

Post May 30th, 2015, 12:01 am

Posts: 102
Points on hand: 809.00 Points
?? just wanted to see some of the projects here, after a long NL2 break, when i realized, that i couldn't log in anymore.
Like you see, my Nickname is now completely messed up, but i like it =D
(No i wont change it, because its epic now). :mrgreen:

The name required UTF-8 encoding on the site and the database ;)

With UTF-8:
Image
Without UTF-8:
Image
(means: "small fox", in german if you're wondering)

Sometimes i give my coasters also german names, that uses those special characters
and im not sure, what would happen, if the title gets messed up. It could be problematic for the search option.

here is an example of a real rollercoaster, that also uses a german name with special characters:
M??useachterbahn
http://rcdb.com/1030.htm

A user sided solution would be:
?? = ae
?? = oe
?? = ue

And i didn't tested the trackexchange, yet.
Its just a small information.

I dont really care, if its changed or not, but dont blame me,
if i upload "M??useachterbahn" into your trackexchange and your database crashes ;)

Post May 30th, 2015, 7:36 am

Posts: 1410
Points on hand: 5,149.54 Points
Bank: 0.00 Points
Location: SW Pennsylvania


Post May 30th, 2015, 10:11 am

Posts: 8144
Points on hand: 13,491.00 Points
I feel "Special Characters" are also messed up in other contents here, such as Exchange, Forum, User Avatar, and so on. Coding bugs still exist. ;) No problem, though.

Since RCT3rox wrote one German message, my turn to put my thoughts in French. Heureux que tu viennes ajouter tes projets 'ci, pour nous satisfier au max ! :D (Happy that you come here and add your projects to satisfy us to the max! :D)
-- I was happy to be with NL1 - [:')] --

Post May 30th, 2015, 10:42 am
Paradox User avatar
Moderator
Moderator

Posts: 6144
Points on hand: 7,113.00 Points
Bank: 10,198.60 Points
Location: USA
This has been going on for a while now even quotation marks are messed up.
Coasterkidmwm wrote:
gouldy wrote:
Just don't employ stupid people and you're golden.

That's like finding a Waffle House with no white trash in it.

Post May 30th, 2015, 12:36 pm
Metazoanhaddock User avatar
Moderator
Moderator

Posts: 1758
Points on hand: 3,382.00 Points
Bank: 52,337.00 Points
Location: Seattle, Washington
This just highlights why we need a coder

so who'd like to donate?
Head Moderator
Director, Structural Engineer - PEAK Amusements
Site Contest Judge (Supporting)
Chatroom Admin

Post May 30th, 2015, 12:50 pm
mkingy User avatar
Moderator
Moderator

Posts: 5462
Points on hand: 28,116.00 Points
Bank: 0.00 Points
Location: United Kingdom
This all occurred during the database rollback of 2015.
Coaster Count - 198
France 2019 Mini Trip Report

Post May 30th, 2015, 8:02 pm
Mikey User avatar
Site Admin
Site Admin

Posts: 1598
Points on hand: 6,054.50 Points
Location: Houston, Texas

PHPBB supports UTF8 data types out of the box, but unfortunately the URL rewriter that makes the structured urls for the site does not. You can upload your track with special characters, but you won't be able to view the page or download the tracks because the URL will 404. The only way we would be able to get around this would be to string replace the special characters inline or disable pretty urls for special characters.
Image

Post May 31st, 2015, 1:46 pm
Dirk_Ermen User avatar
True Addicts
True Addicts

Posts: 13387
Points on hand: 2,180.50 Points
Bank: 45,000.00 Points
Location: Noord-Brabant, Netherlands
Willkommen zur??ck auf Coastercrazy ;)
Coastercount: 1410 (I've seen the world and it's horrid contraptions... @.@)
- Wood: 142
- Steel: 1268

Post June 12th, 2015, 8:43 pm
TTD03 User avatar
True Addicts
True Addicts

Posts: 7306
Points on hand: 738.00 Points
Bank: 111,265.11 Points
But then why did the username corrupt Mikey? It was fine before?

Post June 13th, 2015, 1:25 pm
Oscar User avatar
Founding Member
Founding Member

Posts: 14409
Points on hand: 11,994.60 Points
Bank: 187,052.60 Points
Location: California, USA

TTD03 wrote:
But then why did the username corrupt Mikey? It was fine before?

Just issues with the conversion from snitz to phpbb.
Support Us! - Click Here To Donate $5 Monthly!
Paradox wrote:
No need to tell Oscar about the problems. He is magic.

Post June 14th, 2015, 9:55 am
TTD03 User avatar
True Addicts
True Addicts

Posts: 7306
Points on hand: 738.00 Points
Bank: 111,265.11 Points
Oscar wrote:
TTD03 wrote:
But then why did the username corrupt Mikey? It was fine before?

Just issues with the conversion from snitz to phpbb.

-_-
But he came here after the switch.


Return to Site Related

 


  • Related topics
    Replies
    Views
    Last post
cron