Re: Binary(250) Primary Key

Posted in 1998

Art S. Kagel — Thu, 12 Mar 1998 12:05:14 -0500 — source: Informix-list mailing list archive (1991-1998)

Birdman wrote: > > Hi, > Use varchar(250). Varchar is no good. The column will truncate on insert at the first NULL byte. However CHAR(251) will work the extra byte is to insure that the first byte is not NULL in which case the engine will consider the column as containing a NULL for that row. If you insert the key with the same leading, non-zero, byte the key ordering and indexing will not be affected. Art S. Kagel