Page 1 of 1

Truncating data manually or letting MySQL auto truncate?

Posted: Mon Jan 26, 2009 7:42 am
by exesteam
Hello there

I read Stefan Esser's ebook and it told me to use STRICT_ALL_TABLES for MySQL which makes it to not truncate data passed into database. Now I wonder if it's good to truncate on PHP because PHP is slower than MySQL in truncation. Also, I do not see problems in MySQL's auto truncation IF we handle truncation attacks properly. Agree?