|
> Lets say aMsgCode = '12bbbbbbbb' (Where b is a blank). > After execution of step 1, the value of bMsgCode is same > as aMsgCode, but I want the value of bMsgCode as '12nnnnnnnn' > (Where n is the null value). Null is an unfortunate word because it means several things to different programmers. C/ASCII programmers think of Null as being x'00' - a string terminator. SQL programmers think of NULL as a column attribute meaning 'no value assigned.' And then there is a group who confuse x'00' with x'40'... In your example, I would probably define bMsgCode as varying. Then it only contains '12' and nothing after it. Translating it to ASCII is another issue. You probably don't really want to send a string of x'00' to the other side; perhaps only one at the end of the '12'. If that is the case, I would simply concatenate x'00' to the end of bMsgCode. --buck
As an Amazon Associate we earn from qualifying purchases.
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.