CiviCRM Community Forums (archive)

Hi.

  This is a strange one.. Some things that come to mind are Addresses settings- http://www.example.com/civicrm/admin/setting/preferences/address?reset=1
If you do have your site online i could peek real quick to check the settings or import mappings.

 FYI. - Civicrm stores state_province internally as a 4 digit code.
------------------------------------------------------------------------------------------------------
CREATE TABLE civicrm_state_province (
     id int unsigned NOT NULL AUTO_INCREMENT  COMMENT 'State / Province ID',
     name varchar(64)    COMMENT 'Name of State / Province',
     abbreviation varchar(4)    COMMENT '2-4 Character Abbreviation of State / Province',
     country_id int unsigned NOT NULL   COMMENT 'ID of Country that State / Province belong' ,
    PRIMARY KEY ( id ),
    UNIQUE INDEX UI_name_country_id(name, country_id),     
     CONSTRAINT FK_civicrm_state_province_country_id FOREIGN KEY (country_id) REFERENCES civicrm_country(id)   
)  ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;
------------------------------------------------------------------------------------------------------
INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(1000, 1228, "AL", "Alabama"),
(1001, 1228, "AK", "Alaska"),
------------------------------------------------------------------------------------------------------

HTH.
Yashesh