Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  Move data from memo field in Access database to SQ

Author  Topic  KhD Starting Member 6 Posts Posted - 2011-10-03 : 22:11:13 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!