nvarchar fields

[shlomi_weiss2]

Hi all

I have a UNX universe over SQl server 2012

My data contains English and Hebrew characters, so my data type is nvarchar to support it

I have a customer field and let's assume that it has 2 members

1. Costso

2. מכבי

The customer field is defined as nvarchar

I've built a query over customer and when I filter it by Costco, it works fine

But when I filter it by מכבי, it doesn't bring back any record

I know that in TSQL I have to use N'מכבי' or N'Costco'

but how do I use that in the universe???

regards

Shlomi

[former_member4998 · Accepted solution]

Hi ..

If you create a dimension “Customer” and while running the Q on customer, able to see the

1. 1. Costso
2. 2. מכבי

In the LOV’s.

If you able to see just select the “מכבי” and run the Query, then Select the View query script button and copy and run on the SQL server and check able to see the data or not  for “מכבי”from DB.

Find the below notes for more info

2010794 - N character is not added in the where clause if choosing Result from another query even when UNICODE_STRINGS is set as Yes in Universe Designer Tool

1773856 - Web Intelligence cannot retrieve data when using nvarchar object as prompt

1543761 - "Non Supported datatype" error in Rich Client while creating reports based on a jdbc connection based universe

1355597 - Universe can not recognize Oracle NCHAR and NVARCHAR2 data when database's character set is set to non-UTF

[former_member4998 · Accepted solution]

Hi

Is your problem had solve?

PLEASE mark blog as helpful & answered