confluence not displaying single quote correctly

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 '

1 answer

0 vote

Hey Ed,

I guess you are troubleshooting just right your application(yeaaah smile).
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 smile.

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


Cheers buddy!

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

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

381 views 21 10
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you