Developers,

I have run out of hair trying to figure out the solution to this problem. This is what I have:

I have a MS Access database with a table containing both Chinese Traditional, Chinese Simplified, and PinYin data. The problem is that the data is in ascii format. For example, here are some sample columns with their data:

TraditionalColumn = "ªº"
PinYinColumn = " d="

What I need to be able to do is to take this ascii data and convert the data to the following:
ConTraditionalValue = "的"
ConPinYinValue = "dé"

I do know that "ªº" can be converted to hex A4A4 which corresponds to the Big5 character table as "的". My question is, how do I do this via C#?

Thanks for everyone's help on this.

--Bastre