[resolved] UTF-8 encoding with MSSQL Input

One Star

[resolved] UTF-8 encoding with MSSQL Input

Hi
Is there a way to change an ISO encoded MSSQL Input to UTF-8? Saving the input as a file and use the tChangeFileEncoding component would be a possible workaround, but a rather ugly one.
Thanks in advance for your support.

Accepted Solutions
One Star

Re: [resolved] UTF-8 encoding with MSSQL Input

Ok, I just had to deactivate "use an existing connection", now I can see the additional JDBC parameters under advanced settings.
Thanks a lot!

All Replies
Moderator

Re: [resolved] UTF-8 encoding with MSSQL Input

Hi,
Have you tried to set Additional  JDBC Parameter character Encoding=UTF-8 in advanced settings of  tMSSqlInput component?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] UTF-8 encoding with MSSQL Input

Hi Sabrina
I'm using tMSSQLInput, not tMySQLInput, and the MSSQL connector offers no additional settings.
I'll try to change the encoding in tJavaRow, maybe this works.
Best regards
Tom
Moderator

Re: [resolved] UTF-8 encoding with MSSQL Input

Hi,
Can you get "Additional JDBC Parameters" field on your tMSSQLInput component?
Please take a look at screenshot.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] UTF-8 encoding with MSSQL Input

Ok, I just had to deactivate "use an existing connection", now I can see the additional JDBC parameters under advanced settings.
Thanks a lot!