I'm currently working on a new (for me) legacy database that store percentile numbers in a varchar column . Seriously who the fuck had the that brilliant idea!!!

  • 4
  • 1
    Wait until you find decimal values stored as varchar in a fairly new system 😫
    For added fun, the values are padded to length 32 with #
  • 1
  • 0
    if it's php, then most likely to avoid the semi random type casting that makes precision impossible
Add Comment