Functions aside. This is not a question asked in the context of functions to which I might want to pass parameters which need to specify datatype and length.

I am speaking in the context of building a database with tables that will later be indexed and queried against. Considerations are database storage space, indexing, caching...that sort of thing.