Liam,
Thanks for the suggestion. I am still working on the save and I may need to do something like this. I appreciate the good idea.
Kind Regards,
Mat
P.S. My 6 year old son is named Liam. I have only been to Ireland once (10 years ago), but I loved it and can not wait to go back.
>Hi Mat,
>
>I was having similar problems saving encrypted information to a PostgreSQL database. What I ended up doing was running it thru a routine that converted each character to its ASCII value and then doing the reverse when I extracted the information from the database.
>Eg "065:066:067:" = "ABC". Simple but effective.
>
>Regards,
>
>Liam
>
>
>
>
>
>>Jos,
>>
>>You are right, the binary memo does work correctly, so the null character is causing an end of string. I was trying to avoid memo, but I may not have a choice?
>>
>>I also need to store this in a SQL database, I will have to test the field types there. Thanks for your help and quick replies.
>>
>>Kind Regards,
>>
>>Mat
>>
>>>Mat,
>>>
>>>It would appear that VFP is treating the CHR(0) as the null character - end of string terminator? I am not sure what you can do then? Have you tried the binary memo field or does that cause its own set of problems?
>>>
>>>Jos
>>>