the short answer: declare it as type BIGINT.