Hi experts,
I have a report in which I need to filter out some values based on a string that contains accented characters. I tried creating the following filter:
Employee Name <> 'NÃO SE APLICA'
The resultset was retrieved with the 'NÃO SE APLICA' record, to my surprise. Then, I decided to perform the following test:
Employee Name not like '%SE APLICA%'
Now I have the expected resultsed. I.e., the aforementioned Employee wasn't there.
I believe that the problem is in the Content Store charset. (I'm using Oracle 11g). I understand that the charset needs to be AL32UTF8 or ALT32UTF16. Unfortunately, the DBA isn't available at the moment and I can't check that such charset is defined for my Content Store. So I decided to consult with you guys to check whether I'm on the right track or I need to investigate something else.
Any help is appreciated,
Matheus
Just an update:
I've confirmed that the content store now has charset AL32UTF8 and the problem persists. Is there a way to discover the exact query that Cognos is passing over to Oracle? The Generated SQL option is not an option, because if I get that query and run against the database directly, I get the expected results. I.e. NÃO SE APLICA is not in the resultset.
Cheers,
matheus
Hello,
I'm facing the same problem... Have you found a solution?
Thanks,
Hello my friends,
Please, we have a similar problem, filtering not working when text have accents...
Have you find a solution to this??
Thank you!