RE: Binary data in char/varchar column?

Posted in 1994

"Paul Hatcher" — Sun, 27 Feb 1994 11:23:18 GMT — source: Informix-list mailing list archive (1991-1998)

> Article: 5985 of comp.databases.informix > Newsgroups: comp.databases.informix > Path: cix.compulink.co.uk!uknet!EU.net!uunet!shared!jimf > From: jimf@shared.com (Jim Franklin) > Subject: Binary data in char/varchar column? > Message-ID: <1994Feb25.224420.55188@shared.com> > Sender: jimf@shared.com (Jim Franklin) > Date: Fri, 25 Feb 94 22:44:20 GMT > Organization: Shared Financial Systems, Dallas, TX > Lines: 16 > > I have the desire/urging to populate a char or varchar column with > binary data. The SQL reference manual indicates that char & varchar > data types may contain "tabs and spaces, but no other nonprinting > characters". This data is not to accessed with normal SQL or any > other Informix tool. Does anyone have knowledge in this area. We > will be using ESQL/C & OnLine 5.0. > > Replies from all directions would be appreciated. > > Thanks, > Jim > -- Why don't you put it in a BYTE blob instead? Paul Hatcher Graduate Associates Ltd +44 81 840 3110 - Phone phatcher@cix.compulink.co.uk +44 81 567 1894 - Fax