Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Unanswered: Move data from memo field in Access database to SQL Server 2005 database


    I need to move double-byte data(multi-language) from Memo field in Access database to nvarchar(max) field in SQL Server 2005 database.

    I wrote a routine for this using C# in Visual Studio. If I directly transfer the data, all I see in SQL Server is "???????" when there are non-English characters.

    How can I transfer the data so that I see actual characters and not ???. Do I need to convert the encoding?


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Odds are good that you've selected a font without Unicode glyphs for the characters that are causing problems. If you are using the Query Window inside of SSMS (SQL Server Management Studio), you need to change the font for the result set.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts