I have been breaking my mind the whole day trying to do the following thing.
My native language is Spanish and I need to import some words which have accents. I got to upload those words properly in Teradata setting the upload to UTF8.
But then, when I execute an export query ussing SET SESSION CHARSET UTF-8, the results are exported in ANSI, as I see using Notepad++ & Encoding.
I already changed the language setting in the .sh and .bat files of Pentaho, but I think my problem is that I am not being able to bring the data in UTF-8 format. Is there anyway to export in UTF-8 format?
Furthermore, I tried to execute an SQL Script in Pentaho just to run the SET SESSION CHARSET UTF-8, but It launched an error.