Author Topic: Special characters result in database error when Post attempted  (Read 3645 times)

0 Members and 1 Guest are viewing this topic.

Bert Remington

  • Grease Monkey
  • ****
  • Posts: 441
  • Karma: 0
I created a Reply using Notepad and using Charmap inserted the U+00B0 Degree Sign character as in 30 degree angle.  Repeated Post attempts resulted in a database error.  Changing the Degree Sign to "degree" resulted in successful Post.  If full range of Unicode is not accepted, perhaps a character filter when entering text could be added.  Actually this would be an excellent security measure as there are certain Unicode tricks that can be harmful.
2016 RE Classic 500 CA version Fair-Weather Mountain Bike
2014 Can-Am Spyder RT-S SE6 Freeway Commuter Pod


Guaire

  • Grand Gearhead
  • *****
  • Posts: 1,982
  • Karma: 0
What does any of that mean in the real world?
ACE Motors - sales & administration


Richard230

  • Grand Gearhead
  • *****
  • Posts: 6,048
  • Karma: 0
I don't even know what it means in my world, much less the real world.  ::)
2018 16.6 kWh Zero S, 2009 BMW F650GS, 2020 KTM Duke 390, 2002 Yamaha FZ1


Guaire

  • Grand Gearhead
  • *****
  • Posts: 1,982
  • Karma: 0
I don't even know what it means in my world, much less the real world.  ::)

Richard230 - When I get your address I'll send you a postcard from the real world. Then you can say you get mail from the real world.
ACE Motors - sales & administration


Bilgemaster

  • Just some guy
  • Global Moderator
  • Grand Gearhead
  • *****
  • Posts: 3,251
  • Karma: 1
  • 2005 Bullet 500ES in "Mean Green" Military Trim
What does any of that mean in the real world?

What this means in the real world is that if you try to properly spell something with most any letter, numeral or symbol not shown on your Yankee keyboard, and occasionally even a few that are such as apostrophes, then the new Forum system shrugs and takes a shit.

I've noticed some of my past postings with characters such as a degree symbol, fractions, accent marks, umlauts and even humble apostrophes now instead display a consistent jumbly symbol salad like "’" (for an apostrophe) or "è" (for an "e" with an accent aigu, such as found in many French words).

A long series of global replacements run throughout the database tables could repair this, though I would be surprised if the Forum system vendor, Simple Machines, did not already have an easier fix on tap.
« Last Edit: August 28, 2018, 11:02:11 pm by Bilgemaster »
So badass my Enfield's actually illegal  in India. Yet it squeaks by here in Virginia.

 


Arizoni

  • Grand Gearhead
  • *****
  • Posts: 7,412
  • Karma: 2
  • "But it's a dry heat here in Arizona
For what it's worth, I just had the forum refuse to post my latest thoughts in the Iron Barrel section.

I found the reason after reading this topic. 

I had used the "Alt 0 1 7 6" code (without the spaces) that normally creates a degree sign in the text.  It didn't like that at all and kept giving me the thumbs down warning that ends up with Contact an administrator.

I did send a PT (Private Topic) to one of them but at the time I sent it, I didn't know what the problem was.

Now that I know, I'll avoid using the "Alt+number" codes in my posts.
Jim
2011 G5 Deluxe
1999 Miata 10th Anniversary