Is varchar a good candidate for primary key?

Is varchar a good candidate for primary key?



The answer is: No.

Variable-length data is a poor choice to be a primary key. It is better to use fixed length data such as Int, BigInt or CHAR(10) for a primary key candidate.