Java long to MySql

Question

What is the equivalent of a Java long in the context of MySql variables?

score 83 · Accepted Answer · answered Sep 23 '10 at 18:03

83

SIGNED BIGINT is a 8-bytes long integer just like Java's long.

answered Sep 23 '10 at 18:03

Crozin

42,946
13
87
135

21

Note that in MySQL all `INT` types are signed by default. – NullUserException Sep 23 '10 at 18:05

score 19 · Answer 2 · answered Apr 19 '18 at 19:01

Java long max value is positive: 9,223,372,036,854,775,807

This means for positive only unsigned numbers UNSIGNED BIGINT(19) should be enough or you can just use UNSIGNED BIGINT which is equal to UNSIGNED BIGINT(20)

If you are going to use negative numbers as well BIGINT(19) will be enough.

Java long to MySql

2 Answers2

Linked