Special Characters getting replaced in Output tool

Hi,

I have a below issue with special characters.

Ex1: Input - £100 fixed rate

Output - #100 fixed rate.

The pound sign replaces with # in output

Ex2: Input - Children’s Hospital

Output - Children?s Hospital

The ' sign is getting replaced with ? in output.

Can someone please guide me here. Thanks in advance !

Accepted answers

Finally, I got the solution.

The Force SQL WChar Support should be ticked.

Sharing the screenshot below for reference.

Are you trying to save in the .CSV format to save?

If yes, you need to change the below setting in configuration window.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

Thank you @ShankerV

I am trying to save in *.xlsx instead of .csv

Is it possible ?

Finally, I got the solution.

The Force SQL WChar Support should be ticked.

Sharing the screenshot below for reference.