7

I just don't get people designing database tables using VARCHAR/VARCHAR2 for columns that have numeric values in them, then use them as row identifiers.

I simply don't.

Comments
  • 1
    Not the best practice to do that.
  • 2
    I use varchar for phone numbers and zip codes because of the occasional leading zeros. Would never use it as a unique identifier though.
  • 3
    almost all primary keys in the database at my job are strings... it's terrifying.
  • 1
    Designing databases is not for everyone. I have not seen this kind of stuff in production.
  • 2
    @biondizzle don't forget friendly Canadian Zip codes...
Add Comment