Re: Storing non-printable chars in CHAR columns

In article <11974@cimshop.UUCP> vchow@HP-UX (Victor Chow) writes: > >Now if you need to store a binary value, whose first byte may be '\\0' >(say COBOL low-value), in a CHAR column, how do you work-around >it so that Informix does not consider the value a database NULL >and be able to retrieve the column back with the original value? > >Thanks, Victor > >vchow@buckeye.consilium.com Try escaping the '/0' with a '/1'. This will prevent Informix from treating it as a null and preserve the collating sequence. Cheers -- Stephen Szalla sms@mel.cocam.oz.au Co-Cam Computer Group, Tel: +61 3 286 3456 Melbourne, Australia Fax: +61 3 417 7857