• 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?

    As Steve mentioned, once the data is saved or converted into varchar, there's no way to get the unicode data back.
    If after the data type change, you still can't store the arabic characters correctly, you need to check your string handling. Here's an example of what I mean.

    DECLARE @test-2 TABLE( MyString nvarchar(250));

    INSERT INTO @test-2 VALUES('طالÙٱئذش'); --Random string without any knowledge on what it means
    INSERT INTO @test-2 VALUES(N'طالÙٱئذش');

    SELECT *
    FROM @test-2;

    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