Guest Posted February 11, 2003 Share Posted February 11, 2003 Im trying to input all countries into a zone for shipping in the format... <format> AF,AL,DZ,AS,ADAO,AI,etc... </format> does anyone know where I can download the list in the exact format shown above? Many Thanks Paul Link to comment Share on other sites More sharing options...
Jan0815 Posted February 11, 2003 Share Posted February 11, 2003 http://www.oasis-open.org/cover/iso639a.html is a starting point. Hint: These country codes are an ISO standard, called ISO639. Ask google for ISO639 and you should get happy very soon. You can also take a look at the coutries table of oscommerce, export it as CSV or whatever format you prefer. HTH You can't have everything. That's why trains have difficulty crossing oceans, and hippos did not adapt to fly. -- from the OpenBSD mailinglist. Link to comment Share on other sites More sharing options...
Guest Posted February 11, 2003 Share Posted February 11, 2003 thanks for the help Jan.... here is the string that I was looking for...ill post it here as it may help somone looking in the future <string> AF,AL,DZ,AS,AD,AO,AI,AQ,AG,AR,AM,AW,AU,AT,AZ,BS,BH,BD,BB,BY,BE,BZ,BJ,BM,BT,BO,BA ,BW,BV,BR,IO,BN,BG,BF,BI,KH,CM,CA,CV,KY,CF,TD,CL,CN,CX,CC,CO,KM,CG,CK,CR,CI,HR,CU ,CY,CZ,DK,DJ,DM,DO,TP,EC,EG,SV,GQ,ER,EE,ET,FK,FO,FJ,FI,FR,FX,GF,PF,TF,GA,GM,GE,DE ,GH,GI,GR,GL,GD,GP,GU,GT,GN,GW,GY,HT,HM,HN,HK,HU,IS,IN,ID,IR,IQ,IE,IL,IT,JM,JP,JO ,KZ,KE,KI,KP,KR,KW,KG,LA,LV,LB,LS,LR,LY,LI,LT,LU,MO,MK,MG,MW,MY,MV,ML,MT,MH,MQ,MR ,MU,YT,MX,FM,MD,MC,MN,MS,MA,MZ,MM,NA,NR,NP,NL,AN,NC,NZ,NI,NE,NG,NU,NF,MP,NO,OM,PK ,PW,PA,PG,PY,PE,PH,PN,PL,PT,PR,QA,RE,RO,RU,RW,KN,LC,VC,WS,SM,ST,SA,SN,SC,SL,SG,SK ,SI,SB,SO,ZA,GS,ES,LK,SH,PM,SD,SR,SJ,SZ,SE,CH,SY,TW,TJ,TZ,TH,TG,TK,TO,TT,TN,TR,TM ,TC,TV,UG,UA,AE,GB,US,UM,UY,UZ,VU,VA,VE,VN,VG,VI,WF,EH,YE,YU,ZR,ZM,ZW </string> Cheers Paul Link to comment Share on other sites More sharing options...
Guest Posted February 11, 2003 Share Posted February 11, 2003 ahhh...new problem :( as the string above is more than 255 chars it will not all fit in :( anyone know how I can get it ALL to fit into the zone? or is there some kind of *wildcard* I can insert for countries not already assigned a zone? Cheers Paul Link to comment Share on other sites More sharing options...
burt Posted February 11, 2003 Share Posted February 11, 2003 Use phpmyadmin to increase the size of the field to a "longtext" - I think it is set at varchar(255), which is where your problem is. Link to comment Share on other sites More sharing options...
Guest Posted February 11, 2003 Share Posted February 11, 2003 what table in the database do I find that in? Thanks Paul Link to comment Share on other sites More sharing options...
Guest Posted February 11, 2003 Share Posted February 11, 2003 ok....so I found it in table "configuation"...... thanks for the help :lol: Paul Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.