开发者

Which type should I use to store an ID card in database?

开发者 https://www.devze.com 2023-02-20 13:49 出处：网络

What is the best way to store an ID card number (8 digits) in a d开发者_开发技巧atabase? Integer or VARCHAR(8)? Thanks. I am using PostgreSQL.I will assume MySQL for this question, as you failed to st

相关专题：database

What is the best way to store an ID card number (8 digits) in a d开发者_开发技巧atabase? Integer or VARCHAR(8)? Thanks. I am using PostgreSQL.

I will assume MySQL for this question, as you failed to state any details.

Since it's a numeric value, not a string, I recommend using a numeric type. You can make the best use of space by using the narrowest type that's wide enough in MySQL, which is DECIMAL(8).

Also make the column UNSIGNED, and possibly use ZEROFILL.

Unsigned Integer should be large enough to handle 99999999 since it's max value is 4294967295. Integer should also be faster when searching and will also be a smaller storage data type.