I have question about the best solution to store number code
(example: 1234123412341234).
This code have always 16 chars and is numeric value!
I use InnoDB engine to store table
Currently i have type of column VarChar(16) but i have thoughts whether bigint is better for this.
Column code is not edited after added to database.
分享 Bigint requires 8 Byte to store a number, while varchar(16) will require at minimum the double amount of Bytes. Depending on the character set used, even 4 times more. So type of bigint will save space on your disk but also reduce network traffic.
A varchar(16) will not be able to represent all bigint numbers. An unsigned bigint value of 0xFFFFFFFFFFFFFFFFFE can't be stored in a varchar(16) column.
On machine Level, a 16 Byte comparison usually happens in one cycle, while comparing strings is much more expensive, since varchar requires a byte to byte comparison.
分享
