Text or Number for the ID or Serial field

[GC GYM]

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?

[Vaughan]

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.

[GC GYM]

Ok Thanks Vaughan