Johnathan, I recommend downloading oscommerce and looking at their SQL file. What they do is have address formats because not all address are layed out the same as they are in the US, but more importantly you need to have the conecpt of regions instead of states. Canada has provinces, Japan had prefectures. Create a regions table that maps the state/ province/prefecture to a country, when someone selects the US you populate the region with US states, when they choose canada populate it with the canadian provinces. Postal codes are different around the world. We have a 5 numeral character standard in the US, but other countries include spacing and alpha/numeric characters. Some are more than 5 characters long. Give yourself 20 characters, and validate them for the countries you are familiar with.
James On Dec 23, 2007, at 4:23 PM, Jonathan Franks wrote: > > Are there any best practices recommended for collecting international > postal addresses and for the database structure to contain them?? > > It seems to me that this must be something that lots of people have > worked on before but I've looked online and I can't find much. > > If there isn't anything, perhaps we should build a plugin for this. It > would add to symfony's internationalization and localization arsenal! > > Regards, Jonathan > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
