Pentaho Text Input multiple languages English and Japanese Characters Loaded into MSSQL data table separate columns

Question

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.

score 1 · Accepted Answer · answered May 04 '22 at 13:56

1

I found that it is a simple as setting the encoding to Shift_JS

answered May 04 '22 at 13:56

CPHILLIPS1234

45
4

Pentaho Text Input multiple languages English and Japanese Characters Loaded into MSSQL data table separate columns

1 Answers1