Special Characters on LiveReport Output

Hello,

I have a live report which extracts information from the database, and on one of the output columns I have an integer fields which represent a true or false value.

On the select query I’m doing the a case and replacing the 1 or 0 for “Sim” or “Não”, which means “Yes” and “No” in Portuguese.

The problem is that on the output the “Não” value appear as “N�o”.

I already tried cast the string value to nvarchar but it didn’t resolve the problem.

Any ideas on how to overcame this issue?

Thanks in advance

Best Regards

Ricardo Cartaxo

Find more posts tagged with

Comments

Thomas Heusser

How do you edit the WR? If you edit it in a external Editor (not in the textarea) and import it "add Reportview Version" than doublecheck the encoding of this Editor.

Thomas

Ricardo_Cartaxo

Hello,

Already resolve the issue, I just cast all the case in the select as nvarchar and it the output appears correct.

Thanks