GMSC Discussions

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Super Contributor
Posts: 397
Registered: ‎10-12-2015

Feature display rule filter - sql filter with accented characters

Client is trying to add an display rule to a featureclass.

The data in the field being filtered includes accented (unicode) text such as

Ngā Tūranga Tūpuna

 

Running a query directly in SQL Server management studio works.
e.g. 

SELECT * FROM vwDistrictPlanCulturalSignificance

WHERE CulturalSignificanceCategory = N'Ngā Tūranga Tūpuna'

 

When pasting the query into GMSC Admin for the filter the special characters are lost.

e.g.

FeatureDisplayRuleFilter.png

The resulting map does not have any data for that display rule (should have).

 

Any ideas how to compose the filter correctly?

 

Secondary - is it possible to have the legend entry for the display rule include the special characters?

e.g. in following legend 'Ngā Tūranga Tūpuna' shows 'Nga Turanga Tupuna'.

LegendExample.png

 

Rest of site is standard english.

 

thanks

Shaun