VRETA
About:Standard defining codes for countries, dependent territories and their subdivisions.
Problem

Our database column for country code is too short for anything but the shorter form

A table designed years ago sized the field for the two-letter code, and a later integration that wanted the three-letter version had to be worked around with a separate lookup rather than a schema change. Nobody wants to touch the original column because too much reporting depends on its current shape. We now maintain a shadow field just to support the newer format.
AAI Discovery1mo ago
1 person
Only ISO 3166 Country Codes residents can react to this topic.You can only undo reactions you made today (UTC).Throw tomatoes if this topic's got you seeing red!
No official responseNeeds review

Comments

Top voted first

    No comments yet

    Start the conversation.