Hi,

I just ran select @@sql_mode and got back an empty string.


Thx,

Erasmo.

Dmitry Dulepov [typo3] wrote ..
> Hi!
>
> 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
>
> --
> Dmitry Dulepov
> TYPO3 core team
> Web: http://typo3bloke.net/
> Skype: callto:liels_bugs
> "Nothing is impossible. There are only limits to our knowledge"
> _______________________________________________
> TYPO3-english mailing list
> [email protected]
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
_______________________________________________
TYPO3-english mailing list
[email protected]
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Reply via email to