Arrrrgghhh it appears that statistically, 90% of the questions I post go unanswered. So I 'spose you can create a new rating for me as DUMBF___K.

To clarify the first post. Assume you can input Unicode {let's say html converted to Chinese via Google.translate} into an nVarchar MAX field... However, when you extract the data in SQL or to XML and use any string functions, the Unicode appears to be internally converted to ANSI. But in your text box etc... you want the data to appear as Unicode translated to the charset.

Hope this makes sense

Stan