Re: How to define table ?

"Camus Chan" <camus_chan@ivrs.com> wrote: :Hi ALL, : :I want to define a table which would contain binary data. How to do that :with Informix ? The only way to store binary data directly in current Informix databases (not Universal Server) is to use a BYTE column (a blob). If this isn't appropriate a char column can store anything but a null byte (00 hex). If that isn't good enough you will have to resort to some encoding of your data in a char column. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org