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

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