The database upgrade processing for Zen Cart 1.5.5a makes some corrections/additions to the countries table:
Unfortunately, these language-encoded values are going to look like the following when run against a latin1-collated database:Code:UPDATE countries set countries_name = 'Åland Islands' where countries_iso_code_3 = 'ALA'; UPDATE countries set countries_name = 'Réunion' where countries_iso_code_3 = 'REU'; UPDATE countries set countries_name = "Côte d'Ivoire" where countries_iso_code_3 = 'CIV'; UPDATE countries set countries_name = 'Bonaire, Sint Eustatius and Saba', countries_iso_code_2 = 'BQ', countries_iso_code_3 = 'BES' WHERE countries_iso_code_3 = 'ANT'; INSERT INTO countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) VALUES (247,'Curaçao','CW','CUW','1'); INSERT INTO countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) VALUES (248,'Sint Maarten (Dutch part)','SX','SXM','1');
Should those non-ASCII characters be inserted/updated using their HTML symbols instead, e.g.Code:UPDATE countries set countries_name = 'Åland Islands' where countries_iso_code_3 = 'ALA'; UPDATE countries set countries_name = 'Réunion' where countries_iso_code_3 = 'REU'; UPDATE countries set countries_name = "Côte d'Ivoire" where countries_iso_code_3 = 'CIV'; UPDATE countries set countries_name = 'Bonaire, Sint Eustatius and Saba', countries_iso_code_2 = 'BQ', countries_iso_code_3 = 'BES' WHERE countries_iso_code_3 = 'ANT'; INSERT INTO countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) VALUES (247,'Curaçao','CW','CUW','1'); INSERT INTO countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) VALUES (248,'Sint Maarten (Dutch part)','SX','SXM','1');
Code:UPDATE countries set countries_name = 'Réunion' where countries_iso_code_3 = 'REU';


Reply With Quote
