The Degree Symbol ° Breaks my server

Permalink
Trying to make a Page Name:
High Temp Float Switch - 10 Foot - 225°F/107°C - Normally Open - Intermediate Angle
The ° breaks it. How can I get it to stop trying to make the ° part of the url slug? It is not an option to use the & deg; (had to put a space so the character wouldn't appear) option, because of how I add the pages.

mdius
 
JohntheFish replied on at Permalink Reply
JohntheFish
You could try using the html entity code. Google for HTML special characters.
for example
https://brajeshwar.github.io/entities/...

The code for a degree sign is & deg; or (in hex) & #176; (remove the space after &)
mnakalay replied on at Permalink Reply
mnakalay
I read your thread (and described my own experience) on Github and I'm wondering if maybe what you could do is when creating the page, remove the degree symbols totally from the name then save.

Once the page is created, modify the name (the URL won't change) and add the degree symbols back.

That might work.

As for an explanation, I haven't tried it on 5.7 but, on my install of v8 I didn't have any experience. So either there's a problem with 5.7 (possible, I should try) or maybe your database has the wrong character encoding set.

in phpMyAdmin, when creating the database, you should set it as UTF8 - general. Do you remember what you set it up as?
mdius replied on at Permalink Reply
mdius
I set the SQL as the default setup. So, no idea.

But, yes I add the degree symbol later, which makes it more challenging when duplicating pages in the cart. But it seems like when I edit the page, if I don't change the symbol then, it still errors. My memory stinks, so it usually takes a crash or 2 to remember. LOL

I'll try to figure out the database and see if I can, and if so, it makes a difference.