Could you point what must be configured on a DBF file to correctly save an encripted string?
I'm using vfpencryption71.fll that perfectly runs and correctly saves on a not indexed DBF file.
But if I use an indexed DBF file (I don't know if it's really the cause, this occurs:
*-- The string that must be saved
OµÆp%D½×°W“˜Âá?ËR•(óÏ Sqϧux¹
*-- The string saved
Oü-+p%D+×°W"˜Âá?ËR•(óI SqI§ux1
The DBF index configuration Collate is Machine.
The codepage of the not indexed table and the indexed table is the same 1252.
The problem arises on CDX not in IDX.
Thanks in advance.
Who is Participating?
Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Experts Exchange Solution brought to you by
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trialIt's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
From novice to tech pro — start learning today.
-
Microsoft ApplicationsCertification: MOS Microsoft Office Specialist - Word 2013 Part … 213 lessons
Experts Exchange Solution brought to you by
Important is also the CP used in the application - see CPCURRENT() function.
Or you may define the column with NOCPTRAN keyword - visible as Character (binary) or Memo (binary) in Table designer. In such case the CP conversion is suppressed.
Optionally the varbinary column could be used. This data type also does not allow the conversion.
To convert text into binary data type simply write 0h + "text". Or 0h + variable etc. I would guess the automatic data type conversion works well here.
The string example in your question was converted from CP 1252 to CP 437 or some other MS DOS CP or to a CP which does not support upper index characters like ¹ ² ³.