• VastSQL - Tuesday, March 6, 2018 3:08 AM

    Thanks Luis,

    Data get inserted using Linq query and we tried creating a new nvarchar column inserted into both column the same value at once and the new column is populating data properly but the column we changed from varchar to nvarchar is still showing data as ??

    If it's data that was already in the table before the data type change, then it's lost. You would need to correct it as there's nothing stored that would allow you to identify which were the characters that you intended to store in the first place.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2