[CS-FSLUG] International Data

[Don Parris]

On Wednesday 28 November 2007 13:40, Josiah Ritchie wrote:
> Something new and interesting about my new position here at FIM is the
> consideration of International data. I'm in the early thoughts of
> starting up an open-source project for missionary care, I haven't come
> up with a nam yet. I'm thinking about its requirements in terms of
> database design. I figure a firm foundation would be critical and that
> means a well structured database.
>
> Anyway, the thing that is really floating around in my head right now
> is how a system like this would handle international contact
> information. Each country has their own postal systems and telephone
> systems. How can you store this sort of information in a database
> without creating an unpredictable mess? Usability is also a concern.
>
> Does anyone have any experience in this sort of thing they'd like to share?
>
> JSR/

I think Kontact's Address book is an excellent example of the fields, but I'm 
not sure about the best way to tie them together in a DB.  I just used a 
single table for addresses in CHADDB, but was beginning to use a separate 
table for phone #'s, etc.


-- 
Don, Dolly, Samora & Joshua
https://www.xing.com/profile/Don_Parris
http://www.linkedin.com/in/dcparris