Re: bigint support in MySql 4

[Jeff Mathis]

sorry, I don't know that one. Never have used any version of mysql lower 
than 4.04. a suggestion might be to call your 4.0 column an unsigned 
bigint, or if possible an unsigned int if the numbers can fit in 32 
bits. unsigned means its always positive.

jeff

ps. you may want top "reply all" so the rest of the group can comment. 
you sent it to me directly.

[EMAIL PROTECTED] wrote:
 Thanks for your quick reply. I had another question. I have some tables
with columns of tyoe bigint running on MySql 3.23. When i copied these
tables on to MySql 4.0 the values of these columns are displayed
negative. When I copy them back the values are correctly displayed. Could
you tell me as to how I can handle this situation ?
 yes it does. we use a bigint(20) for example.

[EMAIL PROTECTED] wrote:

Hi,
    I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath


--
Jeff Mathis, Ph.D.                      505-955-1434
The Prediction Company                  [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6        http://www.predict.com
Santa Fe, NM 87505






--
Jeff Mathis, Ph.D.                      505-955-1434
The Prediction Company                  [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6        http://www.predict.com
Santa Fe, NM 87505
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]