I have an .sql file with a few simple "Insert into" SQL commands that are being inserted into a table called Künstler.
insert into Künstler (name) values ('Mariah Carey'); insert into Künstler (name) values ('Michael Jackson');
However upon executing the file through Putty to run all these commands, each line is met with an error;
During SQL processing it returned: SQL0007N The following on "insert into K" mark "▒" is invalid.
It seems the German umlaut characters are being transformed into '▒'
I have enabled UTF-8 on Putty and the commands will work if entered manually, but not as a batch. Is there any work around?
For extra information, the language I am using is DB2.