I have a column which holds the double byte character like japanese.
I want to compare the columns values against the userinput values.
With the simple conditional object it is not working
ex: table.column1= @Prompt('Enter Name','A','class\column Name',Mono,Free)
column1 holds the value ja_リスク
and even if i enter the value ja_リスク to the prompt it is saying no data to fetch.
when i run the report in the sql level then also it is not fetching any result.
but if i give the input with prefixing N' like N'ja_リスク
then it is fetching the data.
How to accomplish this in the universe level. User may have to enter multiple values also sometime