[Mono-list] Cast a char(1) to a boolean

Michael J. Ryan tracker1_lists@theroughnecks.com
Mon, 25 Oct 2004 01:16:04 -0700

Thanks, actually, going to go full on ANSI
SET GLOBAL sql_mode='ansi';

I'm testing with mysql5, so should work out okay.. :)
can I still specify the engine/type in create-table scripts though??

Nick Loeve wrote:
> http://dev.mysql.com/doc/mysql/en/Legal_names.html
> apparently u can use double quotes if you use the ANSI_QUOTES mode option:
> SET sql_mode='ANSI_QUOTES';

Michael J. Ryan - tracker1(at)theroughnecks(dot)com - www.theroughnecks.net
icq: 4935386  -  AIM/AOL: azTracker1  -  Y!: azTracker1  -  MSN/Win: (email)