Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Address formats
02-27-2015, 12:48 AM
Post: #1
Address formats
Would it do any harm to change "address1" on debtorsmaster and suppliers (and any other tables with the same address structure) to a TEXT field?

As "address2" is effectively already reserved for use by the postal town, "address3" for the county/state and so on, this means that all the address before the post town has to be crammed into address1, where VARCHAR(40) is patently inadequate.

Putting the local part of the address into a single field (which can included embedded newlines) also makes searching simpler when you are dealing with addresses where not all lines of the block/street/district are always included because you can run a match/partial match against a single field instead of having to check two or three different fields.
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Address formats - tomglare - 02-27-2015 12:48 AM
RE: Address formats - phil - 02-27-2015, 09:44 AM
RE: Address formats - tomglare - 03-02-2015, 09:05 PM
RE: Address formats - phil - 03-04-2015, 03:45 PM
RE: Address formats - tomglare - 03-05-2015, 08:52 PM
RE: Address formats - falkoner - 03-10-2015, 07:37 PM
RE: Address formats - tomglare - 03-10-2015, 08:07 PM
RE: Address formats - falkoner - 03-10-2015, 08:14 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)