Answers.Body: <p>Actually I don't think it is the ID, rather it is the 'abbreviation' which in the case of Viet Nam have all been entered in to table civicrm_state_province as numbers.</p>
  
  <pre><code>SELECT * from `civicrm_state_province`
  WHERE country_id = 1233
  </code></pre>
  
  <p>whereas eg US ones are of type WV (West Virginia) etc</p>
  
  <p>I don't know how bad it would be to suggest you copy the 'name' field and paste in to the 'abbreviation' field as a really bad hack.</p>
  
  <p>I know I also raised this on the <a href="https://forum.civicrm.org/index.php/topic,34019.0.html" rel="nofollow">forum</a> in the past with the hope of a solution so that there was a setting you could nominate to use either the Abbreviation or the Name on the Contacts Summary screen</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-19T04:09:11.067Z
Answers.Text: Hi Peter...sorry it took so long to come back to this but ran into the same problem again today. I wonder where these numbers they are using for abbreviations came from. I don't know if VN has official abbreviations but I am sure they are not numbers. It would be nice if someone from civicrm.org would get involved in this after several years of bringing it up.
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-19T04:23:35.987Z
Answers.Text: I just looked at https://en.wikipedia.org/wiki/ISO_3166-2:VN and see what the source of the numbers is. It is the code column in the ISO 3166-2 table but without the preceding "VN".  I also noticed that in the CiviCRM table, the names have been anglicized so that a province like Đắk Lắk is spelled Dac Lac in the CiviCRM table.
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-19T05:33:25.457Z
Answers.Text: Correct - they are the ISO number
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-24T01:39:50.993Z
Answers.Text: This is still an issue. I don't mind fixing the table but I'm afraid it would be lost in an update.
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-24T01:52:35.640Z
Answers.Text: What I'd like to be able to do is use a token for the fully spelled out province name instead of fiddlling with the table. Right now, the only token available is the abbreviation, which is just a number. Same for Cambodia.
Answers.UserDisplayName: Vietyank
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-26T07:01:31.560Z
Answers.LastActivityDate: 2016-04-26T07:01:31.560Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Same problem here in Ireland.
  <a href="https://civicrm.stackexchange.com/questions/37951">Export full state name - not abbreviation</a>
  The solution is needed for most countries apart from USA and Canada. The exports need to include civicrm_state_province name as well as civicrm_state_province abbreviation.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-25T19:12:08.913Z
Answers.Text: is this an Answer or a Comment?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-27T01:39:25.243Z
Answers.Text: This does not really answer the question. If you have a different question, you can ask it by clicking [Ask Question](https://civicrm.stackexchange.com/questions/ask). To get notified when this question gets new answers, you can [follow this question](https://meta.stackexchange.com/q/345661). Once you have enough [reputation](https://civicrm.stackexchange.com/help/whats-reputation), you can also [add a bounty](https://civicrm.stackexchange.com/help/privileges/set-bounties) to draw more attention to this question. - [From Review](/review/late-answers/11807)
Answers.UserDisplayName: Luke Stewart
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-14T11:52:24.397Z
Answers.Text: Including civicrm_state_province name as well as civicrm_state_province abbreviation in the exports would answer the problem.
Answers.UserDisplayName: jamesleahy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-11-25T15:16:28.507Z
Answers.LastActivityDate: 2021-11-25T15:16:28.507Z
Answers.UserDisplayName: jamesleahy
Body: <p>Most of my contacts have Vietnamese addresses. When I enter the name (organization or individual), I see the correct name for the Vietnamese provinces in the list and choose one. When I view the contact details, the name of the province displays as a number (the id, I presume) instead of the name.</p>
  
  <p>I have reported this several times on the old forum but never got a solution to the problem.</p>
  
Tags: <contacts><addresses>
Title: State/Province display for a contact shows a number instead of the name for Vietnam contacts
ThreadText: # State/Province display for a contact shows a number instead of the name for Vietnam contacts
  
  (Asked by: username_0 on 2016-04-26)
  
  Most of my contacts have Vietnamese addresses. When I enter the name (organization or individual), I see the correct name for the Vietnamese provinces in the list and choose one. When I view the contact details, the name of the province displays as a number (the id, I presume) instead of the name.
  
  I have reported this several times on the old forum but never got a solution to the problem.
  
  **Tags:** contacts, addresses
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-04-26. Score: 3
  
  Actually I don't think it is the ID, rather it is the 'abbreviation' which in the case of Viet Nam have all been entered in to table civicrm\_state\_province as numbers.
  
  ```
  SELECT * from `civicrm_state_province`
  WHERE country_id = 1233
  
  ```
  
  whereas eg US ones are of type WV (West Virginia) etc
  
  I don't know how bad it would be to suggest you copy the 'name' field and paste in to the 'abbreviation' field as a really bad hack.
  
  I know I also raised this on the [forum](https://forum.civicrm.org/index.php/topic,34019.0.html) in the past with the hope of a solution so that there was a setting you could nominate to use either the Abbreviation or the Name on the Contacts Summary screen
  
  > **Comments:**
  > **username_0**: Hi Peter...sorry it took so long to come back to this but ran into the same problem again today. I wonder where these numbers they are using for abbreviations came from. I don't know if VN has official abbreviations but I am sure they are not numbers. It would be nice if someone from civicrm.org would get involved in this after several years of bringing it up.  
  > **username_0**: I just looked at https://en.wikipedia.org/wiki/ISO_3166-2:VN and see what the source of the numbers is. It is the code column in the ISO 3166-2 table but without the preceding "VN".  I also noticed that in the CiviCRM table, the names have been anglicized so that a province like Đắk Lắk is spelled Dac Lac in the CiviCRM table.  
  > **username_1**: Correct - they are the ISO number  
  > **username_0**: This is still an issue. I don't mind fixing the table but I'm afraid it would be lost in an update.  
  > **username_0**: What I'd like to be able to do is use a token for the fully spelled out province name instead of fiddlling with the table. Right now, the only token available is the abbreviation, which is just a number. Same for Cambodia.  
  
  ---
  
  ### Answer by username_2 on 2021-11-25. Score: 0
  
  Same problem here in Ireland.
  [Export full state name - not abbreviation](https://civicrm.stackexchange.com/questions/37951)
  The solution is needed for most countries apart from USA and Canada. The exports need to include civicrm\_state\_province name as well as civicrm\_state\_province abbreviation.
  
  > **Comments:**
  > **username_1**: is this an Answer or a Comment?  
  > **username_3**: This does not really answer the question. If you have a different question, you can ask it by clicking [Ask Question](https://civicrm.stackexchange.com/questions/ask). To get notified when this question gets new answers, you can [follow this question](https://meta.stackexchange.com/q/345661). Once you have enough [reputation](https://civicrm.stackexchange.com/help/whats-reputation), you can also [add a bounty](https://civicrm.stackexchange.com/help/privileges/set-bounties) to draw more attention to this question. - [From Review](/review/late-answers/11807)  
  > **username_2**: Including civicrm_state_province name as well as civicrm_state_province abbreviation in the exports would answer the problem.  
  
  ---
  
  