Josh Berkus <[EMAIL PROTECTED]> writes:

> > - Usage of varchar for key column
> 
> And?  Varchar is somehow implicitly inferior for keys?

Yes, it's larger and larger is slower. It's also failure prone when pushed
through various levels of applications prone to uppercasing or misparsing
whitespace. It's also prone to failure in internationalized applications and
applications dealing with multiple character sets.

> Watch it ... you're about to hit one of my "abuses of SQL" pet-peeves, the 
> overuse on INT surrogate keys ...

Oh yeah, and it's also a sign you're failing to use surrogate keys and using
something meaningful in the real world as your primary key and therefore
vulnerable to major problems when the real world fails your assumptions about
uniqueness or immutability.

-- 
greg


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to