>Why would you convert it back ?
>
>If you assign it the data from the table, and it displays well, then the format is ok - I'd say

I can select CONVERT(varbinary(max), MyNvarcharField) in VFP and I can then assign it to the textbox.text - this part works.

However, trying

replace myField with ActiveX.Text

update myTable set myNvarcharField = convert(nvarchar(100), ?myVFPCursor.MyField)

does not work.

I don't know what to try. Wondering, if someone can try the same experiment I'm trying - it should be very simple to set it up. Create a SQL Server table with the nvarchar(100) field. Insert in SSMS any unicode data into this field.

Thanks a lot in advance if someone can help me out.