My source has a text data with all spacial characters like trade marks and Register Marks, While moving to Target as text, I am getting some spcial characters before registration marks and ? marks before single quotes. I have used utf-8 encoding etc, still no use, I am not seeing trademark sign like TM, i see ¢.
Is there any alternative solution to this?
Any thoughts ???
Strange, that "Cash+â„¢ SignatureÂ®" does look like UTF-8. However, it might be going through a double conversion - UTF-8 being re-encoded into UTF-8 as if it were not already. Do you have any intermediate steps that might be being written as one format e.g. UTF-8 but read as another e.g. ISO-8859?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.