>>>I was asking if I should use nchar() vs. char() type, specifically. But I still would like to know a case of what value stored in the SQL Server tables char() type would cause a problem? and what kind of a problem?
>>
>>Again I would repeat varbinary(). Not char or nchar.
>>As I said before, your encryption result has non-printable characters.
>
>Do I understand that varbinary() would have to be mapped to char(binary) type field in VFP?. And I am not sure that it would work with cursor adapter via ODBC. Doesn't it requires either OleDb driver or Chen's updated VFP?
Yes, varbinary maps to char (nocptrans), memo or (naturally) blob.
It does work with CA. I have no idea about Chen's VFP.