Why such inconsistency? Shouldn't they all return the same?

>>Are you saying that NCHAR or NTEXT column wouldn't return Unicode?
>>
>That is exactly what I am saying, you don't get Unicode on VFP side.
>
>>Can you clarify how mapping to MEMO field vs a character field affects result?
>>
>Mapping NVARCHAR field to a character field doesn't return Unicode string.
>Mapping NVARCHAR field to a MEMO field returns Unicode string.
>
>
>>>I believe Unicode string is returned only for NVARCHAR field and only if it is mapped to a MEMO field.