Convert ANSI to UTF in T-SQL, replacing German Umlaut ‘ß’ results in replacement of ‘ss’ as well

I’m trying to convert ANSI strings to UTF for the use in JSON format for HTTP requests.

Convert ANSI to UTF in T-SQL, replacing German Umlaut ‘ß’ results in replacement of ‘ss’ as well

I’m trying to convert ANSI strings to UTF for the use in JSON format for HTTP requests.