McGill will double your password if you don’t do it first

Re:McGill will double your password if you don’t do it first by reberhardt on Tuesday November 18, 2014 @11:48PM (#8628337)

In addition to the frontend issue mod mentioned, it often happens accidentally without any errors or warnings when using a VARCHAR in a relational database, which have a maximum length. If the username field is VARCHAR(20), the application ignores database truncation warnings, and the developer didn't think to check the username length before storing it in the database, it'll truncate a 21-character username without you knowing. This comes down to the devs using sensible field lengths and handling edge cases.

[ Parent | on HN ]

Re:McGill will double your password if you don’t do it first by desas on Wednesday November 19, 2014 @04:03AM (#8628974)

I think mysql is the only database that auto truncates varchars isn't it?

[ Parent | on HN ]