I mistakenly had a field set to text instead of ntext. We had some Arabic associates write text into this field, so it saved the data as ???? instead of the Arabic language. I need to know if there is a way to pull that data out of the text field and translate it into the Arabic characters. I have updated the field to ntext now, but of course that doesn't translate the data back to how it was entered into the database. I would appreciate any help you can give me on this. I also tried this statement, but it didn't work.
CAST(comment AS ntext) COLLATE Arabic_CI_AS
Thanks!