Changing Big Big integer Value

2007-08-10 Thread Stephen Sunderlin
I've recently converted a CRM database with about 20k entries. I exported the data to ACCESS had to tweak the field names and value then Inserted all into mySQL with mySQL Administrator. During the conversion out of the CRM into ACCESS the unique Primary Key for each contact, which is also the F

big big integer

2003-08-16 Thread Doruk Fisek
Hi, It is noted in the MySQL manual that unsigned integers bigger than 9223372036854775807 (63 bits) shouldn't be used itnarithmetic operations since signed BIGINT/DOUBLE is used in arithmetic functions. Can we somehow tell MySQL (probably during compilation) to use unsigned BIGINT/DOUBLE for a

Re: Big Integer

2001-01-25 Thread Scott Baker
to be able to store 96 bit >numbers. As I understand it, however, the largest size that can be stored >in MySQL is 2^64 using Big Integer. Has anyone run into this problem >before? Does anyone know of an easy work around for this? Thanks! >Please CC me on any replies as

Big Integer

2001-01-25 Thread Ashutosh Somani
Hi, I am working on an application where I need to be able to store 96 bit numbers. As I understand it, however, the largest size that can be stored in MySQL is 2^64 using Big Integer. Has anyone run into this problem before? Does anyone know of an easy work around for this? Thanks! Please CC