I am attempting to send a statement to an SQL2000 data source from VFP6.0. The output is going into a cursor where I am receiving some "weird" data. Some of the queried fields have a black, vertical mark replacing the final character. Upon further research, I found that all of these fields have the data type NVARCHAR in SQL2000. I am familiar with VARCHAR and CHAR but not with NVARCHAR or NCHAR. It seems that NVARCHAR is unicode and actually of smaller capacity that VARCHAR. That is the extent of my knowledge but it is happening on all fields with this data type.

I am able to restructure the query using CAST and CONVERT to convert the data type to VARCHAR with successful returns...this is very cumbersome though.

Does anyone know if this is an issue with FoxPro? If anyone has any help to offer it would be greatly appreciated. Thanks.