Context: Feature Type with a WHERE clause
Purpose: To only read records relating to a user defined Iwi (Maori Tribe).
When the WHERE Clause is, for example: "IWI"='Whakatōhea', the transaction is successful and returns the expected records.
However, when the WHERE Clause is set with a User Parameter "IWI"='$(IWI)'
and the User Parameter is set with the value Whakatōhea, the transaction is successful but no records are found.
This behavior is only affecting records with macronated vowels, which is common in Maori language.
Users need to be able to input their Iwi of interest for this workbench.
Can anyone suggest where the WHERE clause setup might fail?
Many thanks