General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Standard length fields
>
>Most of my database design is aimed to Mexico and Latin America. However, this time I need to create a database where common used standard fields will be there for the American and International user.
>
>I’ll appreciate any advice about field lengths for the next list of fields.
>
>Thanks in advance
>
>Phone
>Addres
>City
>Social Security No.
>Zip
>First Name
>Last Name
>Second Name
>
>Oscar
You might want to add two more five-character name fields: prefix and suffix. Prefix can hold titles like "Dr." or "Capt." and suffix can have things like "Jr." or "III". I once worked on a large software product that had those fields.
Many English and some Americans have four names. I have always wondered where they put them in databases. Maybe they squeeze both middle names into the middle name field.
I read in a tourist guide to Mexico that Mexicans who have three names use the middle name as a surname. That must be why your third name field is called "Second Name". The book was explaining that if someone mailed a package to a Mexican post office addressed to an American tourist named Michael Edward Smith, they might file it under Edward, not Smith, and Mr. Smith would not find it unless he knew to look under "E". And, I guess, Carlos Salinas de Gotari would be "Mr. Salinas" or "Mr. Salinas de Gotari". Maybe that would not affect your table structure, but it could affect your interface. An American might enter Salinas in the middle name field and Gotari in the last name field. The database would generate correspondence saying "Dear Mr. Gotari:". Or he might put all of "Salinas de Gotari" in the last name field.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only