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
If it's not broken, fix it until it is.
My Blog