Understandable. If you want to store the extra characters, as far as I know, you will have to make the fields in the database char or varchar fields and type the data in as you want to store it. I seem to recall that Access allowed one to specify storage of telephone numbers as formatted data, but I'm sure MySQL doesn't. I haven't worked with dBase or FoxPro in so many years that I don't know if either of them allow storage of formatted data. Perhaps someone else knows a way, but I rather think you'll have to type the entire text you want to save. Otherwise, you'll have to change your workflow to minimize editing raw data.
John On Sat, Oct 17, 2009 at 3:35 PM, <[email protected]> wrote: > > Hi jomali, > > > > Why would you want to waste space in the database to store the > parentheses, spaces and dash < > > > > At least in my case, because I often modify data in the raw stored database > format, and it is easier if the format is easy to read, and storage space > and computer speed to scan it are now _very_ cheap. > > > > I'm mostly speaking of use in dBase and FoxPro as I am just slowly learning > / converting to OO Base. > > > > Bob >
