Hi,
I am trying to get a unicode field from a MSSQL2000 table but I have problems.
This table contains a field defined as nvarchar(500) type. In this case VFP creates a cursor using a memo field to store the value. The value is still in unicode format.
I get something like "B a n a n a " insted of "Banana".
I know that I can handle this problem in SQL converting the nvarchar field to varchar. But, there is some way to handle it in my VFP application?

This problem happens only with Memo fields, it doesn´t happen with nvarchar and the size is less than 255. My question is, why VFP handle in different ways?

Thanks.
Ricardo.