Storing and retreiving rich text from MySQL to rich textbox

[tomi.trescak@gmail.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:

{
tf1ansiansicpg1 250deff0deflang 1029{fonttbl{f0 fnilfcharset0
Arial;}{f1fnilf charset238 Microsoft Sans Serif;}}
viewkind4uc1par dlang1033fs16 rtyrtyrtlang102 9f1fs17par
}

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

[Jim Langston]

Re: Storing and retreiving rich text from MySQL to rich textbox

<tomi.trescak@g mail.comwrote in message
news:1157669736 .047254.182120@ i42g2000cwa.goo glegroups.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:
>
{
tf1ansiansicpg1 250deff0deflang 1029{fonttbl{f0 fnilfcharset0
Arial;}{f1fnilf charset238 Microsoft Sans Serif;}}
viewkind4uc1par dlang1033fs16 rtyrtyrtlang102 9f1fs17par
}
>
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.