Skip to Content
Former Member
Sep 28, 2011 at 02:25 PM

double byte character comparison



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