Storing and retreiving rich text from MySQL to rich textbox

tomi.trescak

Hi

I have a problem with storing rich text in MySQL.
I store rich text in MySQL (in column with type "text") which i get
from Rich Textbox control. When i do reverse processing by trying to
fill rich text back to rich techbox (i set correct property "Rtf") i
get whole text like:

{
tf1ansiansicpg1250deff0deflang1029{fonttbl{f0fnilf charset0
Arial;}{f1fnilfcharset238 Microsoft Sans Serif;}}
viewkind4uc1pardlang1033fs16 rtyrtyrtlang1029f1fs17par
}

There must be some kind of conversion which i cannot discover ;(
Everything works ok when i store this in Access.

Any help apprecitiated. Thank in advance.

Tomi

Sep 7 '06 #1

Jim Langston

<to**********@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

Hi

I have a problem with storing rich text in MySQL.
I store rich text in MySQL (in column with type "text") which i get
from Rich Textbox control. When i do reverse processing by trying to
fill rich text back to rich techbox (i set correct property "Rtf") i
get whole text like:

{
tf1ansiansicpg1250deff0deflang1029{fonttbl{f0fnilf charset0
Arial;}{f1fnilfcharset238 Microsoft Sans Serif;}}
viewkind4uc1pardlang1033fs16 rtyrtyrtlang1029f1fs17par
}

There must be some kind of conversion which i cannot discover ;(
Everything works ok when i store this in Access.

Any help apprecitiated. Thank in advance.

Tomi

Try storing it in a blob and see if you get what you expect. I believe (but
am not positive) that rich text contains binary data.

Sep 9 '06 #2