double byte character comparison

[Former Member]

Hi,

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

Thanks

[Former Member]

Hi,

Found one solution, In universe>parameters>we have one parameter called "UNICODE_STRINGS" by default it value is set to No. make it to Yes and replace it. this will append N to all the prompt values. So that we can compare nvarchar-multibyte characters.

but the issue with this method is, it will prefix N for all the prompt values. this will lead problem in oracle i.e. when we are filter on varchar column. It will give character set mismatch error, as we are comparing varchar clumn with nvarchar value (i.e. selected prompt value).

is there any better way to do this