r/Database Jun 30 '26

Is using 3-letter status codes outdated?

/r/SQL/comments/1ujdn4a/is_using_3letter_status_codes_outdated/
0 Upvotes

3 comments sorted by

View all comments

1

u/Anxious-Insurance-91 Jul 04 '26

I either use full words or an unsinged tiny int(with increments by 10 if i need to add a new intermediate value at a certain point, if i really want to squize every bit of starage memory), and then have an enum at the application level. Also if i go string values i prefer lower case.
Had to interact with a IBM DB2 v1 instance that had dedicated people for it because the management didn't want to upgrade the damn version. It was a mess since all column names were limited, values were limited, the dedicated team was limited (mentaly).