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 '
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).
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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