To the best of my knowledge, once the data is stored in the varchar column, there's no way to translate it into the original Unicode characters. Sure, you could do a CONVERT to get it to a Unicode data type, but the Unicode isn't what's stored in the table. The code page is different.

If anyone has any mechanism that can extract the original Unicode data from the garbled mess, I'd also be very interested in it.