I am trying to load a SQL table with a text file. I am using the Text File Input Step. All but one column may contain Japanese characters(Comment). How can I pass all English text and Japanese text as readable characters? Is there a regex or Java Script code that will pass all of these characters or some other step that Pentaho offers? I prefer not to alter the server if possible.

I am at a loss.

Thanks in advance.