Hi There,
This is probably a stupid question and very likely a lost cause but I'll ask anyway. I have inherited a database which has been used for surveys. The surveys have been run across Europe so obviously there are some interesting characters captured, in particular Russian.
Strangely the columns capturing the answers in free text are varchar and not nvarchar so that data captured is pretty much garbage. Is there any possibility that I can salvage the data? I have tried a select convert to nvarchar with no luck.
Any help will be appreciated.
Thanks in advance.