...
Request: The opportunity title on an application contains an unsupported character, resulting in an error which states "Must be an alphanumeric character or punctuation".
This often happens when the title contains a non-ASCII character, such as "smart quotes" or long hyphens copied from Word/Outlook/etc.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
update eps_proposal set program_announcement_title='DoD Peer Reviewed Alzheimer''s, Research Partnership Award' where proposal_number='5997'; -- The double apostrophe in Alzheimer''s results in a single apostrophe in the final output update s2s_opportunity set opportunity_title='DoD Peer Reviewed Alzheimer''s, Research Partnership Award' where proposal_number='5997'; |
...