How to: Prevent Translation of Data in Character or Memo Fields
In some cases you don't want automatic code page translation. For instance, if a character field contains an encrypted password, you don't want Visual FoxPro to automatically translate the password because doing so would alter it.
To prevent translation of data in a character or memo field
Open the project containing the table.
Select the table.
Choose the Modify button.
The Table Designer (Visual FoxPro) appears.
Select the field whose data you want to protect.
From the Type list select Character (Binary) for a Character field, or Memo (Binary) for a memo field.
Choose OK, and then choose Yes to make the changes permanent.
Verify the changes by displaying the structure of the table with the DISPLAY STRUCTURE Command.
Alternatively, use the MODIFY STRUCTURE Command to protect the appropriate fields.
You can also prevent translation of selected characters in text files by using the CHR( ) Function.
See Also
Tasks
How to: Determine the Code Page of a Project File
Concepts
Specification of Code Pages for Variables
Reference
Code Pages Supported by Visual FoxPro