Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


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




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: