Itqualityassurance
Truncating a username is a bad idea. Usernames are used to uniquely identify a person on your site, so if you're randomly hiding part of the name, that's defeating the whole purpose of the username.
What is a truncated name?
Then we usually know it's truncated. Sometimes it's cut off between characters and sometimes a character is cut off so it looks like another character, but usually it's clear that it's cut off, and then we know we're not seeing the full and proper name.
What is the purpose of truncating?
TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes, and so on remain. To remove the table definition in addition to its data, use the DROP TABLE statement.
