Thread: Country Codes
View Single Post
  #8 (permalink)  
Old May 28th, 2008, 09:21
AntonyC AntonyC is offline
Junior Member
 
Join Date: May 2008
Location: UK
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
AntonyC is on a distinguished road
Send a message via AIM to AntonyC Send a message via Skype™ to AntonyC
Re: Country Codes

Hi Laxman,
I don't know of any property or setting that allows you to change from 3 to 2 digits.

The only way i've seen this done before at another client was they updated all the 3 digit country codes in the country_code table with the 2 digit equivalant (as DBA.ADMIN). To associate the country codes with a time zone you will also need to update the country_code3_gid in the time_zone_locale table.

Word of caution though, the scripts to do this will have to form part of your post upgrade process as any upgrade to the db will overwrite the changes.

Rgrds,
Antony
__________________
Antony Carter
Mavenwire

www.MavenWire.com
Reply With Quote