Text filters not being applied on accented strings

[Matheus]

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

[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

[tontonfa]

Hello,

I'm facing the same problem... Have you found a solution?

Thanks,

[crispalier]

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!