By default no special modes are enabled. See http://dev.mysql.com/doc/mysql/en/server-sql-mode.html for information about all available modes and the default behaviour in 5.0.