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).
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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