I am using Access database for one system, and SQL server for another system. The data gets synced between these two systems. The problem is that one of the fields in a table in Access database is a Memo field which is in double-byte format. When I read this data using .Net DataGridView in a Windows form, the text is displayed as ???. Also, when data from this field is inserted in SQL server database nvarchar(max) field, non-English characters are inserted as ???.


How can I fetch data from memo field, convert its encoding to Unicode, so that it appears correctly in SQL server database as well?
Please help!!!