@inthehands I want to give an example of this.
Friend of mine is IT guy for a non-software firm that uses a major db vendor and uses another third-party database set of tables, etc. And they have addons from another company.
Neither of these products use boolean column types. So the first set uses "Y" or "N" as a bool, and the second was written in Iceland, so decided to use "J" and "N" instead.
This kind of thing is just trivially awful, but chews up just great wads of time.