Well, the SQL version of CTY.DAT loads perfectly and I wind up with the two
tables (country and prefix).
The ampersand continuation is indeed not used in CTY.DAT, but I notice it is
used in CQWW.CTY. However, CTY.DAT is the better one to use since it
contains all the info in one file.
The 4U1VIC entries aren't duplicates. One of them (the IAURU Headquarters
entity) has the asterisk in front of it, indicating it is a separate entity *only* in
CQWW contests. It is not a DXCC entity, and outside CQWW contests it
counts as OE, as indicated by the line without the '*', which credits 4U1VIC
to OE. Don't ask me why! See the readme file that comes with CTY.DAT for
details.
I haven't tried the Perl CTY->SQL converter yet, will do so tonight, but I am
sure it will work fine.
I had a quick look around to see where CT gets the 'subentities' info from (the
stuff about VK6 being Zone 29 etc). It doesn't appear to be in the CTY.DAT
or any other files...if I can't figure it out I will ask on the CT reflector.
Wilbert ZL2BSJ
