You can use the "--ansi" startup option to require MYSQLD to use ANSI mode.
Running the server in ANSI mode is the same as the effect of starting it with this option (specifying the "--sql_mode" value on one line):
--transaction-isolation=SERIALIZABLE
--sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
IGNORE_SPACE
In MySQL4.1, you can use the following two statements to achieve the same effect (Specify a "Sql_mode" value on one line):
SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET GLOBAL sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
IGNORE_SPACE';
In the MySQL 4.1.1, you can also set the Sql_mode option with the following statement:
SET GLOBAL sql_mode='ansi';
In this case, set the value of the Sql_mode variable to all the options associated with ANSI mode. You can check the results as follows:
mysql> SET GLOBAL sql_mode='ansi';
mysql> SELECT @@global.sql_mode;
-> 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
IGNORE_SPACE,ANSI';