There is a problem with data for states in SOME countries in the Civi database. For an undetermined number of countries, state abbreviations are stored in the database as digits rather than actual abbreviations, hence the odd display of some international addresses (like those for Austria).

I made a temporary fix in Civi where Civi is set to display full state names rather than abbreviations. This is kind of a lame fix because there are places in Civi where ONLY abbreviations are displayed.

I'm looking into an actual solution to the problem.

Where does this state data come from? Is it supplied with Civi or did we put it in ourselves at some point?

(In reply to comment #2)

Where does this state data come from? Is it supplied with Civi or did we put it
in ourselves at some point?

18:29 < awjr> dlobo: any idea where the state information for countries originally came from?
18:29 < awjr> and btw, there are 47 affected countries
18:29 < dlobo> awjr: some iso spec
18:29 < dlobo> iso-3166 i think
18:29 < dlobo> piotr will know the exact details

47 Countries are affected:

mysql> select s.country_id, c.name from civicrm_state_province s, civicrm_country c where c.id = s.country_id and s.abbreviation rlike '[0-9]' group by s.country_id;
+------------+--------------------------------------+

+------------+--------------------------------------+

+------------+--------------------------------------+
47 rows in set (0.01 sec)

Tried making direct contact with Piotr (the guy who presumably handled getting country info into the db) with no luck, posted on Civi forums to get more info about how they generated the info originally and how I might go about fixing this:

http://forum.civicrm.org/index.php/topic,15431.new.html

We've found an interim solution for this problem and have reported this issue to the CiviCRM community multiple times now. Since we have a workaround for this in place and we do not have the bandwidth to fix the third party product, I'm marking as wontfix. Hopefully this will be fully resolved in a future release of CiviCRM.

[Moving from "CiviCRM/General" to "Wikimedia/CiviCRM; see bug 57738]