May 27, 201213 yr Should the auto enter ID or Serial number field be defined as text or number. I've seen both used. Does it not matter as long as every pk and fk uses the same type?
May 27, 201213 yr I use number fields. That way they sort as expected. (A text field will sort 1, 10, 100, 2, 3 ... ) They also take less storage for indexing.
Create an account or sign in to comment