How to accept data/convert data with special characters i.e. apostrophe, dashes, etc

[LW-doa1408]

Hello, I'm load'g data from a txt file where some fields may have apostrophe (Emily's Place) or dashes or even slashes (/ \).  The data is valid.  There are cases when a record is read where 3 of the fields have special characters - I'm using a select tool to change the format to write into an oracle database.  The surprising then is the 1st field containing some data is converted and written correctly; however, the subsequent fields containing the special characters recv error : could not fully converted from a WString to a  String.

The input tool is already configured to use code page UTF-8

How to resolve using Alteryx?

Here's a simple workflow sample:

[rfoster7]

Can't you just change the datatype on the select tool prior to the output to leave it wstring? Why are you converting to string? Is it a requirement for writing to your oracle database? 

[LW-doa1408]

Yes, I tried that - I still receive the error