question

I have a table User with UserName and Id.

This table can have special characters in the Username field:

Id UserName

1 Ær

2 År

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.

SpecialChar UTFChar

 Â

à Ã

Ä Ã„

Å Ã…

Æ Ã†

Now i want to write a query to update the table User with the replacement UTFChar for SpecialChar found in the UserName

something like:

update User set UserName = Replace(UserName, SpecialChar, UTFChar)

but what do i join these tables on.

Please help on this.