× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Gerald,

Consider putting a before update/insert trigger on the table to convert
those x'41' bytes to blank.

An SQL statement like this should work to convert existing x'41' values in
the table:

update MY_TABLE
set MY_COLUMN = replace( MY_COLUMN, x'41', ' ' )
where locate( x'41', MY_COLUMN ) > 0

Mike



date: Tue, 5 Jul 2016 15:14:49 -0500
from: Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
subject: users pasting hex '41' into char fields...

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


------------------------------

message: 7
date: Tue, 5 Jul 2016 15:36:46 -0500
from: Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
subject: Re: users pasting hex '41' into char fields...

ok....
has anyone used this "translate table" feature of new ACS?


I said to translate 0x41 to 0x40..... now it turns my "A" (hex C1) to
Blanks....




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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.