Friday, June 29, 2012

Do NEVER let user type in country name

It's really easier to maintain full list of countries in DB than end up with such (growing day by day) list for Great Britain only (authentic data from production):
CENTRE LONDON 
UNITED KINGDOM
U?K
NORTHERN IRELAND
WEST MIDS
CENTRE LONDON
WEST YORKSHIRE
ENGLAQND
UK 
?UK
GB,UNITED KINGDOM
GB
ENGLAND
N.IRELAND
MIDDLESEX
CORNWALL
GREAT BRITAIN
U.K.
WALES
NIRELAND