Dmitry Dulepov [typo3] wrote: on 06.01.2008 18:12: > Ernesto Baschny [cron IT] wrote: >> There is no problem with mysql5, just configure it not to use "strict" >> mode. The default Windows mysql installation will include a "SQL-MODE" >> line with some STRICT instructions. Just uncomment that line, restart >> mysql and it should work. > > According to [1] by default mysql comes without any mode, which seems to > be equal to 4.x defaults. Here is a quote: > > -------------- > 27.3.7: What is the default server SQL mode when My SQL 5.0 is installed? > > By default, no special modes are enabled. See Section 5.1.6, “SQL > Modes”, for information about all available modes and MySQL's default > behavior. -------------- > > So it depends either on distribution or om the person, who configured > mysql. I checked mine SuSE 10.3 with MySQL 5.0.45. Its "select > @@sql_mode" produces empty string for sql_mode. > > [1] > http://dev.mysql.com/doc/refman/5.0/en/faqs-sql-modes.html#qandaitem-27-3-7
That might be true for the source code which defaults to "none" if no setting is made, but I recall several windows installations from the official "setup.exe" from mysql.com which installed a my.ini with the strict modes "ON"! I just installed mysql-essential-5.0.45-win32.msi: The installation is pretty easy, and after installed it opens the "MySQL Server Instance Configuration Wizard". Somewhere in step 5 or 6 there is a question about "Enable Strict Mode", which is checked by default. Comment is "It is recommended to enable this option". After finished, I get: # Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" in my.ini. Cheers, Ernesto _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
