BIT(64) Field

TomMettam's profile image TomMettam posted 3 years ago in General Permalink

MariaDB Server 10.4.13

CREATE TABLE `permissions` (
  `key` varchar(50) NOT NULL,
  `group` int(10) unsigned NOT NULL,
  `bit` bit(64) NOT NULL,
  `riskLevel` enum('Low','Medium','High') NOT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

MariaDB only shows 8 bits from the bit column.

How can I get it to display the full 64 bits?

1 attachment(s):
  • f1df4091073c7c9d19d4638bf6f76d4b
TomMettam's profile image TomMettam posted 3 years ago Permalink

(Sorry, I meant HeidiSQL only shows 8 bits.. this forum software is pretty awful and doesn't seem to let me edit a post.. :()

ansgar's profile image ansgar posted 3 years ago Permalink

Can confirm that. HeidiSQL has some issues with bit fields. And I suppose this one is due to bit values casted to 32bit integer's, probably. Althought in that case that should be at least 10 digits. I'm not sure.

Please login to leave a reply, or register at first.