Apostrophe problem ?

Started by robbob
6 replies 9 likes 0 followers Last activity: 9 years ago
#7

Apostrophe problem ?

Keep up the good work Stephen, you're doing a great job 👍 Imagine if you were using a German keyboard like I have to 😉 have to keep switching input languages, otherwise the apostrophe comes out as "~", just one example amongst many 😲
Young at heart 😉 Slightly older in other places.😊 Cheers Doug
Liked by John2
#6

Apostrophe problem ?

Rob its simple ( honest ) there are control characters within the code being used and the apostrophe is one of them. So when you use one the code "sees" it as a control not text.
"that's not a bug its just an undocumented creature."

Sir Terence David John "Terry" Pratchett, OBE (28 April 1948 - 12 March 2015)
Liked by John2 and RNinMunich
#5

Apostrophe problem ?

Hi Stephen.
Thanks for the explanation even though most of it went waaaaay over my head.
I quite an advocate of correct grammar and punctuation (but not a pedant!) so I'll keep using the apostrophe but
I don't envy your task of fixing the problem.
I'll try to resist the urge to use emojis 😉 .......failed.
Robbob.
"Time flies like an arrow; fruit flies like a banana"
Liked by John2 and Colin H
#4

Apostrophe problem ?

There is a technical explanation. Also it's something that is fixable. I simply haven't had the chance to do this as it would need to be fixed at the same time as all database queries. The website has lots!

When loading data into a database there are apostrophes already within the server code itself. To avoid it getting confused on what is code and what is the text it's copying in, it uses a backslash. Otherwise known as an escape character. You'll also see it in RSS feeds sometimes, similar principle there. it's likely what the BBC ticker tape is reading.

That said, queries can be designed differently, the editing scripts are different to the creation scripts for posts on here. All however need a revamp as technology has moved on quite a bit since the original server code was written. There is a new technology called SQL improved, which is much more secure than the old SQL and negates the need for escape characters (back slashes).

When will it be fixed? I can't say. Maybe these Christmas holidays. it's solid days of work to update the whole website to the new technology. The database is a fundamental part of every webpage, the mobile apps, rss feeds and the notification system.

Once things are upgraded I'll be fixing all past posts to ensure no more backslashes are around.

Ps. Don't mention emoji compatibility! That's a whole other headache to manage 😉

Stephen
We may not be able to control the wind 🍃 but we can always adjust our sails ⛵ - MBW Admin
Liked by John2 and cenbeth
#3

Apostrophe problem ?

Equally curious is the fact that in my original forum post the apostrophes in my last line "It's quite curious isn't it ?" appear correctly but used in a
blog text will appear as garbage that needs subsequent editing.
And I have also noticed the odd capitalisation of the letter 'I'
Robbob.
"Time flies like an arrow; fruit flies like a banana"
Liked by John2
#2

Apostrophe problem ?

Even the BBC has this problem, in the ticker tape on the their early morning news programme. Very annoying. Also, whilst on the topic, why in the build blogs does a capital I get used when it should be lower case?

Chris
Liked by John2
#1

Apostrophe problem ?

Why is it that whenever I use an apostrophe in my build blog text it appears as a bunch of seemingly random characters.
I can edit the posting to correct it and it then works, but why not in the original posting ?
It's quite, curious isn't it ?
Robbob.
"Time flies like an arrow; fruit flies like a banana"

Sign in to add to this thread.

Delete this post?

It will be removed from the site.

Discard this draft?

Your draft will be deleted and cannot be recovered.

You have an unfinished draft

What would you like to do with it?