Not really sure what that N is doing in front of the '家庭' - i.e. outside the string quotes. CASE WHEN has nothing to do with character sets - your platform can either handle it or not. First test: can you even display Chinese characters coming from a column or just display them as text? Because the
Note: I just used random chars from the unicode table in this example
The "N" in front is to tell SQL Server (or client) to take the following text as unicode (required for chinese and similar languages).
When OBIEE send the query to SQL Server without the "N" the chinese text is treated as varchar (non-unicode) and result into ??.
I guess I saw a note on MOS about how to handle that, just can't remember when/where and how to find it again.
User472204-OC : did you already searched in MOS or asked Oracle? (because of the -OC I guess you are also an Oracle employee, so must be easy to ask your colleagues )
Ah ok so SQL Server-specific. I was wondering what that's supposed to do in an agnostic formula. Reminder to all reading this: Just because you're using SQL Server doesn't mean the syntax in RPD or Answers has anything to do with SQL Server. It's source agnostic!
So User472204-OC (nice name by the way) key question remains: Is your source actually configured as a unicode source?
It does work.
Thank you very much.