In Outlook, the street field seems to contain new line characters which are stored in a Var field in the database. My existing mysql database uses fields Address1, Address2, Address3 which would correspond to the street field.

I don't want to rewrite my application. Is some form of parsing possible between the two schemes?

How would database applications generally handle editing the field? phpMyAdmin screws up the newlines as soon as any editing is performed.

If your database supports Views it is possible to write SQL statement (behind the View)with some parsing.

"How would database applications generally handle editing the field?"
No Idea

The answer is that the demo sql table definition has varchar for the field type "street". It would be better if this were a text field for mysql. Mysql then represents the line feeds properly.