read and store in database the cell content with multi font color and size

[jsb1921]

Multiple font color/sizes in one cell beautifully explains how to store Multiple font color/sizes in one cell. I am interested in the reverse. using vba, I am reading the cells.value(row, col) and inserting to a mysql database. every thing is working ok, except, I am losing the font/ size of part of the hilighted text in my database.

...
value1=Chr(34) + Cells(row, "A").Value)+ Chr(34)
value2=Chr(34) + Cells(row, "B").Value)+ Chr(34)
sql = "INSERT INTO table1 (col1, col2) VALUES (" + value1 + "," + value2 + ");"
conn.Execute sql
...

is there a way I can retrieve value1 and store in mysql without loosing its color/size in part of the text in a cell value.
vaguely can I get retrive something like Semper Fi or apply a richtext conversion or html conversion or something.

Appreciate all help

 

[jsb1921]

the last line above should read:
vaguely can I get something like

...
[COLOR="Red"][SIZE="3"]Semper Fi[/SIZE][/COLOR] :rambo:
...

or can I apply any richtext conversion or html conversion or escaping or something.