I'm trying to find the best column type to use for numeric values of varying length both before and after the decimal place.
The DECIMAL type seems to only allow a fixed-length number with a fixed-length also after the decimal. I need something that preserves to exact precision numbers like:
I can't find anything other than varchar that clearly accommodates this. Am I missing something?