Re: What is max. column name size?

Michael Burr <michael.n.burr@boeing.com> wrote: :Greetings everyone, : :I've got a couple really basic questions about Informix that I'd like to :know for comparison with Oracle and DB2. Thanks in advance for your :consideration. There is lots of technical information like this at the Informix web site (www.informix.com). You can download the manuals starting from http://www.informix.com/wgs/ or more directly from: http://www.informix.com/answers/answers/english/pubs.htm :1. When naming columns: : : A. How long can names be? 18 characters. : B. What characters can be used (any special characters illegal) ? Names are: first char letter or _ (underline), second and later characters can also include digits (0 - 9). Normally letter is a - z (case insensitive). If you set up GLS (or NLS on older versions) you *can* use special characters (like the extra characters in many european languages). Generally I find this a very bad idea, but it is supported. :2. What data types does Informix support? I'm talking standard builtin : data types here - user defined or datablade. char (to 32767 or something like that in max size), date, datetime, decimal, float, real, integer, smallint, interval, money, serial (auto incrementing integer), varchar, text (blob with text data), byte (blob with binary data) And then of course in the Universal Server you can define anything you like. : :Thanks much, : :------------ :Michael Burr Boeing Commercial Airplane Group 6-6F43, M/S 20-16 : Email: michael.n.burr@boeing.com 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