After finding my workaround for this issue, I still could not get the HTML escaping right.
Until I found out that that was not a SQL issue but a display issue.
Query: SELECT 'Fish & Chips'
Output: Fish & Chips
Desired: Fish & Chips
After finding my workaround for this issue, I still could not get the HTML escaping right.
Until I found out that that was not a SQL issue but a display issue.
Query: SELECT 'Fish & Chips'
Output: Fish & Chips
Desired: Fish & Chips