Could you point what must be configured on a DBF file to correctly save an encripted string?

Hi Experts

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  

Open in new window

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.
Eduardo FuerteDeveloper and AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"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.

The best Code Page is 0 in this case. Then FoxPro cannot convert it as it does not know how to do it...

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  ¹ ² ³.

Experts Exchange Solution brought to you by

Your issues matter to us.

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 trial
Eduardo FuerteDeveloper and AnalystAuthor Commented:

I just changed the field type to Character Bynary - everithing OK!
Eduardo FuerteDeveloper and AnalystAuthor Commented:
Thank you for help!
It'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.