Share via


Preventing 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

  1. Open the project containing the table.

  2. Select the table.

  3. Choose the Modify button.

    The Table Designer appears.

  4. Select the field whose data you want to protect.

  5. From the Type list select Character (Binary) for a Character field, or Memo (Binary) for a memo field.

  6. Choose OK, and then choose Yes to make the changes permanent.

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

Specification of Code Pages for Variables | Developing International Applications | Code Pages Supported by Visual FoxPro | Code Pages in Visual FoxPro | Determining the Code Page of a Project File