ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How to handle Special Characters

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to handle Special Characters

    I am currently transfering table data from a foxpro data base into AS400 tables. One of the fields was used to hold a password for a particular application access. the password was sent trhough an encryption process before being stored in the table. The encryption is Chr((Asc({some alpha character])*2)+5). This generates characters outside of the norm. Anyway when I send this to the AS400 side(an alpha field) it seeems to work okay until I try to read it an unencrypt it. The unrecognized characters are handled as spaces.

    Can someone help me with this situation?

  • #2
    Re: How to handle Special Characters

    The ASCII characters you have generated have no EBCDIC equiv. You need to decrypt them first, then send and encryt again. A possile option might be to store the password table in the IFS, where it could remain as ACSII.

    Comment

    Working...
    X