• Lynn Pettis - Tuesday, March 6, 2018 8:44 AM

    VastSQL - Monday, March 5, 2018 5:42 AM

    Changed one of the existing column datatype from varchar(250) to nvarchar(250) but the column still showing arabic characters as ??

    How can i resolve this?

    Once the Unicode data was converted to non Unicode data and stored in the varchar(250) column the data is lost.  Converting the column to nvarchar(250) will not recover the data.  You will have to go back to the original source to recover the data.

    Edit:  Should have read further, sorry for repeating what has already been said.

    Thanks Lynn
    I am talking about new data being inserted after changing the data type