>>>I am trying to use the cipher .fll to encrypt passwords that will be stored in a SQL server table and then compared when a user tries to log into an application.
>>>
>>>The encryption works great but it seems that when I save the password via a remote view it changes certain characters; therefore on many occaissions the passwords will never match again.
>>>
>>>I am guessing that this is a setting somewhere in VFP. As far as I know the character field should just accept the data being saved as a literal string. Any ideas?
>>>
>>>TIA,
>>>George
>>
>>problems with the codepage?
>Could be. I'm not real familiar with codepages though. All I know is right now it is set to 1252 (Windows ANSI). I will dig around in this area though. Thanks.

Well, what I ended up doing was changing the field to 'varbinary' instead of varchar. This works but makes me deal with a memo field on the VFP side. Could be worse things I guess.

Thanks,
George