Storing all the text with varcha2(20000) and all binary with BLOB? And translate them at run time? This will definitely lower down the efficiency and raise up the CPU time and storage. But I think it is still tolerable.

I don't think this is a good idea. However making a table for each data type is simply impossible.