confluence not displaying single quote correctly

Question

I am using the Bob Swift Run macro in confluence which pulls a drop down list of contact names from a database as part of the form.  When contact names are inserted into the database with a single like Ed O'Gaile, it looks fine in the table.  However when Confluence pulls the data and you hit the drop down list to select a contact name, the name displays as Ed O'Gaile.  The db tables are created with charset utf8 and confluences charset is also utf8.

I am sure this is something right under my nose, but am banging my head on trying to get the drop down list to display the ' instead of '

Ed Gaile · Answer

Thanks Guilherme.  I did check the schemas default character set and collation and they are utf8 and utf8_general_ci respectively.

Guilherme V. · Answer

Hey Ed,

I guess you are troubleshooting just right your application(yeaaah 
).
Can you check your database's collation?

SELECT object_name(object_id) as TableName, name as ColumnName, collation_name
FROM sys.columns
WHERE collation_name <> 'SQL_Latin1_General_CP1_CS_AS'
AND object_name(object_id) NOT LIKE 'sys%'
AND object_name(object_id) NOT LIKE 'queue%'
AND object_name(object_id) NOT LIKE 'file%'
AND object_name(object_id) NOT LIKE 'spt%'
AND object_name(object_id) NOT LIKE 'MSrep%'

They need to be utf8 as well .

Note: This query is for SQL Server, I hope it's the one you are using(crossing my fingers).

Cheers buddy!