Learn More
Resend Email
7
grumpylady01
8y

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.

undefined

sql

database-design
Favorite
Ranter
Comments
  • 1
    8y
    Not the best practice to do that.
  • 2
    8y
    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
    8y
    almost all primary keys in the database at my job are strings... it's terrifying.
  • 1
    8y
    Designing databases is not for everyone. I have not seen this kind of stuff in production.
  • 2
    8y
    @biondizzle don't forget friendly Canadian Zip codes...
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment