>>>If I use an incrementing number as a surrogate primary key, why should I make it a character field? Tastrade does that
>>
>>Bret,
>>
>>You've heard some decent arguments for using an integer. If I had my guess, and memory still serves right, I'd say Tas didn't use them before is because there was once some trouble using integers together with combos. Integers would really confuse them.
>>
>>Steve
>
>It would be more presize to say that integeres will require some accomodations with combos, and it's really doable.
Was that it? I didn't know what the problem was, exactly. I just remember folks having fits with them, so I didn't do it that way. For a while I did surrogate primary keys with characters. Of course, I use integers now.
Steve
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement