I have a table User with UserName and Id.
This table can have special characters in the Username field:
And multiple other characters
I need to store these characters in their UTF-8 encoded format.
I created another table with the special character and its UTF-8 format.
Now i want to write a query to update the table User with the replacement UTFChar for SpecialChar found in the UserName
update User set UserName = Replace(UserName, SpecialChar, UTFChar)
but what do i join these tables on.
Please help on this.