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

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

    Hi,

    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?

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

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