Re: "how the different types change a database" - not sure what you mean?
Each column can hold a different 'type' of data.? There previously was no way to have formatted text (think of putting new lines where you want and having indents and bold text etc).
The new HTML paragraph type allows formatted text in a column.??
Note: if you have an existing database with a column of type "Paragraph", changing it to "HTML Paragraph" will clear all the data from the column.? I imagine it does that for any data type change.
Toby