MySQL Forums
Forum List  »  Microsoft SQL Server

MySQL vs MS SQL problem
Posted by: Nune Melikyan
Date: October 05, 2009 02:15AM

Hello MySQL Experts,

Please help me to solve this problem,
why in MySQL the query select (1 | 0x80000000) returns = 2147483649,
but in MS SQL = -2147483647 ,
Is there any formula or smth to do in MySQL in order to gain the same result as in MS SQL?

Thanks beforehand.



Edited 1 time(s). Last edit at 10/05/2009 02:19AM by Nune Melikyan.

Options: Reply• Quote


Subject
Written By
Posted
MySQL vs MS SQL problem
October 05, 2009 02:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.