I have a user table which will hold address information for a user. My problem comes in where different countries use different things for their address. Should I store all this different info in different columns, and leave them to allow NULL values, and let the processing page handle things and put stuff where it belongs?
IE: The US has... cities States Zip Codes In say the UK it has... towns/cities counties Postal Code In Algeria... City State/Province/Region Postal Code ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
