If you use MySQL and you did not know about the trucation 'features' of MySQL, then you really should read the MySQL Gotchas page. There are a lot of eye openers in there that would shock users of other DBMSes, but are considered acceptable for developers that have generally only ever used MySQL.

To be fair, here is the PostgreSQL gotchas page.