Re: Primary Key: CHAR vs VARCHAR?

Preston Carter (pcarter@hpcc01.corp.hp.com) wrote: : Somewhere along the way I picked up a belief that it's : a bad idea to use a VARCHAR as a primary key; better to : use a fixed-length CHAR column. But I can't find any : support for this belief in any of the printed material : or in the FAQ. So: Is it better to use CHAR for a : primary key, or worse, or makes no difference? : : Thanks. See Informix SQL:Reference V7.2, p.3-26 `Although the use of VARCHAR economizes on space used in a table, it has no effect on the size of index...' -- S.Oleshko International Data Systems sol@ids.lviv.ua