>> You will be told MySQL doesn't set the standard :-) > the same query in postgresql have have same result of Mysql. And nor does Postgresql.
> Mysql and postgresql have the same behavior and sqlite is different. > > what do you think about this? > where I am mistaking? You are making a mistake in thinking that MySQL and Postgresql are 'right' and sqlite is wrong. There are no strict rules governing this and sqlite defines quite clearly in its documentation the comparison operator rules for fields declared as integer, or string type. If you want numeric/integer comparison in sqlite, you need to define the field as a numeric/integer type. In MySQL and postgresql, they both, if the field is detected by content to be numeric, do a numeric comparison before doing a string comparison. sqlite has "stricter" typing rules. Dave. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
