Re: users pasting hex '41' into char fields...

[Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>]

Thanks for all the replies.

yes, my attempt at suppressing via the "translation table" was
misguided....  my attempt at converting  x41 to x40 was ACTUALLY SAYING
 "on _keyboard_entry_ of a "A", make it a " "...
the feature in ACS asks if you want to translate based on keyboard or
display, both sbcs and dbcs....
I do feel that this data is mostly being copied from outlook,  I have found
instances of notes having the x41 bytes in the middle of a note string.

currently this file is a legacy DDS file, but if I want to "reject" this
byte, as invalid data,  as I am told our mySQL databases do, how would I
code my DDL?




On Tue, Jul 5, 2016 at 3:14 PM, Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
wrote:

> I guess either I am very rare to have this trouble, or I can't google
> right....
>
> we are getting a hex x'41' at the end of some of the character strings
> users are pasting into green screen fields..
>
> two questions: one)  how do I properly fix this?
> two)   how do I practically fix this?
>
> I see in the new ACS emulator there is a "Translation Table", But I wonder
> if that is just for file transfer?!?  I can't seem to get it to "convert
> x41 to x40"...