Failure to recognize ’

Report · Jan 11, 2019

I have extensive records containing dialog edited using CKEditor. It translates father's to father’s and this is how it is stored in the table.

I am pulling the records to make a web page - hundreds of them at a time. I process several text fields (nsvarchar) such as:

<cfset a = '<blockquote class="dkpurplefont">Notes for birth: ' & #GetData.BirthNotes# & '</blockquote>'>

I was using <cfset a = '<blockquote class="dkpurplefont">Notes for birth: #GetData.BirthNotes#</blockquote>'> which should work. I switched it thinking I might solve the issue.

60% of the time I will see "father's" on the completed web page. 40% of the time I see "father?s"

I infer that the engine is choking on the ’ as it processes #GetData.BirthNotes# and I'm guessing it is a speed issue - it is being processed faster that it can interpret. I can't find a way to correct it because, by the time I have access to the data, the errant ? has already been inserted (along with other ? that should be there).

Suggestions?

Report · Jan 13, 2019

Just before appending to file, apply:

Report · Jan 13, 2019

Thanks. Tried that. It seems that the erroneous ? (i.e., fails to

recognize ’) is inserted as a is first set. By the time I can

address the value of a it's too late.

Report · Jan 13, 2019

You could do something like

<cfset a=REReplaceNoCase("<blockquote class=""dkpurplefont"">Notes for birth: #GetData.BirthNotes#</blockquote>", "‘|’", "'", "all")>

Report · Jan 14, 2019

I'll try that but it will be a couple of days.

Report · Jan 14, 2019

If you use canonicalize() prior to inserting the data into the database or adding it to a file, this will remove all HTML entities and set them back to their original value (ie, "’" will be an apostrophe.) Be sure to set both flags to "false", otherwise multiple encoded or nested encoded strings will trigger an error.

HTH,

^ _ ^