Post reply

migrating nvarchar data

  • May 12, 2010 at 1:12 am

    #146936

    Hi folks,

    I have a database that has some foriegn characters in it in the nvarchar fields (maybe arabic).

    Taking a restore of the database and putting it on a different server makes these characters turn into junk.

    How can I move these tables with these character and maintain the format?

  • May 12, 2010 at 2:21 am

    #1166007

    Are the collations the same?

    Hope this helps,
    Rich

    [p]
    [/p]

  • May 12, 2010 at 9:20 pm

    #1166608

    database collations are the same

  • May 12, 2010 at 9:56 pm

    #1166615

    How are you viewing the characters via Managment Studio?

    Is this a straight query as in select * from...

    What about the local server or workstation environment settings, are these always the same?

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

  • May 13, 2010 at 12:49 am

    #1166658

    no server settings are not the same.Install files for East Asian Languages is installed on the server that is showing the data - I am just trying to confirm that is all I need to do as I think the language that I can't see is Korean not arabic.

    I have bcped the table across.

Viewing 5 posts - 1 through 4 (of 4 total)

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