Post reply

Asian characters when moving from Varchar to Nvarchar

  • April 7, 2016 at 10:25 am

    #315295

    Hi, I have a table which has some columns in Varchar format. When I transfer the data from the table (using sql migration wizard) to another table which has the same columns in Nvarchar... the data in the columns turns into something like this - '敎⁷潙歲䤠汳'. Now when I try changing those nvarchar columns back into varchar again...I get question marks in some of the fields.

    Does anyone know how I can fix this and make the data in the Nvarchar table to display latin characters?

  • April 7, 2016 at 10:49 am

    #1870587

    Maybe the package is using an incorrect code page for your varchar column.

    This is weird as it's changing the values completely.

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply