>Here is what I see in afields for this field, what do you think? The field is varbinary in VFP (type Q).
>
>Thanks again.
>
>>>>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.
>>
>>
>>I hope your vfp cursor field is binary, ie NOCPTRANS
The field is binary,
check if the field data is correct
after the replace command.
If it is not the check
replace myField with ActiveX.Text